Displaying a date as text
Hi, I'm new to excel and quite bad at it, so I'd appreciate some help.
The first problem should be quite easy for you... I need a formula to display today's name (6.1.2011 = Thursday) I've found this formula but for some reason it doesn't work =TEXT(TODAY(),"ddd d")
The second problem i have is unsolvable i think :P
I have this school timetable which I made for entire year, and I'd like to make one little timetable at the top of spreadsheet which should change as the days pass... So I'd like to have my little table to fetch date from the big timetable.
In case you didn't understand...
__________________________________________________ _________
|MON 10.1.2011
|_________________________________________________ _________
|Math
|Biology
|English
|_________________________________________________ _________
I want to make a table that'll basically copy this one if 10.1.2011 is today's date.
Thanks.
|