| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically entering date
i am using the below formula to update a date in a cell when another cell is
populated. =IF(B2<"",TODAY(),"") However, when opened the next day the date updates to the current day despite the fact that cell B2 is not modified. Is there a way or formula to ensure that the date remains the same as when it was originally entered? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically filling date of today (without it changing tomorrow) | Excel Discussion (Misc queries) | |||
| Is it possible to automatically change color of cell by keying off the date? | Excel Worksheet Functions | |||
| Automatically Add in 56days to the date | Excel Discussion (Misc queries) | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| Date in descending order to come up automatically in a column? | Excel Worksheet Functions | |||
Threaded Mode
