ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   automatic dates (https://www.excelbanter.com/new-users-excel/156571-automatic-dates.html)

flame

automatic dates
 
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.

macropod

automatic dates
 
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
--
macropod
[MVP - Microsoft Word]
-------------------------

"flame" wrote in message ...
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.



All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com