MrExcel Publishing
Your One Stop for Excel Tips & Solutions

auto date update need help!!!!! any excel guru takers??

Posted by roger on November 16, 2001 4:53 AM

i have a spread sheet which prints out status report every day, i just need to know how the current date can be updated automatically when i open the spread sheet..I have to manually press cntrl key and semi-colon. Sometime i forget thus leading a wrong date being placed in the cell..please assist..roger

Posted by Dank on November 16, 2001 5:06 AM

Why not just use the formula =TODAY()


Posted by Douglas on November 16, 2001 5:08 AM


Try using the formula = TODAY()

Put this in the cell where you normally key Cntr ;
It should put in th current date and update everytime you open the workbook


Posted by Hansoh on November 16, 2001 12:07 PM

as an addendum, you can also use =now(). that will also give you the time of day.

whoever said that users of this message board won't give you time of day?