Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"