ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formula for autodating (https://www.excelbanter.com/excel-programming/271125-re-formula-autodating.html)

Dave Peterson[_3_]

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



All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com