MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Today's date


Posted by RPuckett on January 09, 2002 9:14 AM

It's been awhile folks. How do I set a cell to always have today's date in it when that workbook is opened?

Thanks in advance.


Posted by IML on January 09, 2002 9:16 AM

by formula =today() or =now() (nt)

Posted by Rpuckett on January 09, 2002 9:21 AM

Re: by formula =today() or =now() (nt)

Sorry for wasting your time. In reading the help files I thought that just returned the serial number. I didn't even try it first....a cardinal sin.

Posted by IML on January 09, 2002 9:25 AM

Re: by formula =today() or =now() (nt)

Never a waste of time. If the serial number does happen to pop up, you can always just change the format and it should "stick".