try these cell formulas:
=TODAY() 'gets you the date
=NOW() 'gets you the date and time
=WEEKDAY(serial number, return type) 'gets you the day of the week as
an index number; see Help
then try this formula:
=CHOOSE(WEEKDAY(TODAY(),1), "Sunday", "Monday", "Tuesday", "Wednesday",
"Thursday", "Friday", "Saturday")
"mikelove" wrote in message
...
I have made a calendar in excel that i really like. Everyday when I open
that calendar I want it to show the current date how do i do this. Or can
i
make it so that it highlights the cell in my calendar of the day it is.
thanks
|