automatic dates

F

flame

The boss wants me to create a sign in sheet that has the Day of the Week and
the date at the top. I do not want to manually do this for a whole year.
She seems to think I have free time. Can I get excel to do this for me? I
am not familiar with macros but willing to learn.
 
M

macropod

Hi Flame,

Is this a one-day sign-in sheet? If so, Excel's =TODAY() function will display today's date.

I'll leave the sheet design to you & your boss to work out.

Cheers
 
Top