View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Formula for autodating

You could format it to not show the time, but maybe better would be to use
=today().



Mark wrote:

-----Original Message-----
Mark wrote:
How do I type the formual in a cell for the date to

change
automatic each day I add data into my sheet???


Does adding the formula:
=NOW()

do what you want - always updating? Or, are you looking

for a
time-stamp for each element of data you enter?


Matthew

.


Perfect Matthew,
How do I eliminate the time after the date when I type
=Now()


--

Dave Peterson