| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatically Insert DATE, so that DATE will NOT change
I'm using the following formula
=IF(L8<"",TEXT(TODAY(),"mm/dd/yy"),"") My problem is, everytime I go back to this spreadsheet, the date will change to the current date. I DO NOT want the date to change. The date needs to remain the same date as when the data was entered. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert date automatically | Excel Discussion (Misc queries) | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Threaded Mode
