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()

Regards,
Daniel.

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

Roger

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

Douglas

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?

han