#1   Report Post  
Brody
 
Posts: n/a
Default Automatic date

Is there a way that I can get the date in a cell to change daily without
manually inputting the date in each row.
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=TODAY()

will update each time the worksheet calculates.

In article ,
"Brody" wrote:

Is there a way that I can get the date in a cell to change daily without
manually inputting the date in each row.

  #3   Report Post  
KL
 
Posts: n/a
Default

Hi Brody,

You could use the function =TODAY() which will update with sheet recalc as
time passes.

Regards,
KL

"Brody" wrote in message
...
Is there a way that I can get the date in a cell to change daily without
manually inputting the date in each row.



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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn off automatic date formatting? Nick Turner Excel Discussion (Misc queries) 3 July 13th 06 08:13 AM
Automatic date Mark Renfrow Excel Discussion (Misc queries) 4 July 5th 05 10:38 PM
Automatic Date Update khaji00 Excel Discussion (Misc queries) 2 June 22nd 05 11:48 PM
import csv without automatic date conversion shinta Excel Discussion (Misc queries) 1 May 10th 05 04:28 PM
Automatic Populate Todays Date in Cell when File is Saved. Nello Excel Discussion (Misc queries) 3 April 21st 05 11:08 PM


All times are GMT +1. The time now is 10:26 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"