Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

automatic dates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
flame - 31 Aug 2007 02:30 GMT
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 - 31 Aug 2007 10:31 GMT
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
Signature

macropod
[MVP - Microsoft Word]
-------------------------

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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.