#1   Report Post  
CK
 
Posts: n/a
Default today's date

Good Afternoon,

Is there a function which will update the date in a cell to today's date so
it is always up to date?
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=TODAY()

"CK" wrote in message
...
Good Afternoon,

Is there a function which will update the date in a cell to today's date
so
it is always up to date?



  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default

Use the TODAY function. E.g.,

=TODAY()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CK" wrote in message
...
Good Afternoon,

Is there a function which will update the date in a cell to
today's date so
it is always up to date?



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
How do I filter a list using a greater than todays date function? LV Excel Worksheet Functions 2 April 29th 05 06:07 PM
Automatic Populate Todays Date in Cell when File is Saved. Nello Excel Discussion (Misc queries) 3 April 21st 05 11:08 PM
I want todays date in my spreadsheet to be red. I also want this. Leah Wright New Users to Excel 1 April 14th 05 03:04 PM
Setting today's date automatically in Excel. Ezlpo Excel Worksheet Functions 6 February 11th 05 03:27 PM
Today's Date Jake Excel Discussion (Misc queries) 9 December 17th 04 10:57 PM


All times are GMT +1. The time now is 06:15 PM.

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"