| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recording and saving dates in Excel
I use the formula =if(<cell_ref="X";=today();"") to determine when a report
was changed. However, every time I open the file, the formula always returns todays date (naturally !!). How do I record and save as a fixed entry the date the <cell_ref was changed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Concatenate Daily Recording | Excel Discussion (Misc queries) | |||
| Saving a file while recording a macro | Excel Discussion (Misc queries) | |||
| How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
| saving dates\invoice numbers | Excel Discussion (Misc queries) | |||
| Recording time in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
