View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mp mp is offline
external usenet poster
 
Posts: 70
Default today's date static

Is this the correct formula to have today's date put in a cell
and have it not change tomorrow when you open the spreadsheet?
=VALUE(TODAY())

meaning i could each day copy that down one cell to "date"
todays entries..

in other words, I want an easier way to put today's date in a cell
compared to entering by hand
however Today() will update the next time the ss is opened wont' it?
thanks
mark