| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maintain date once entered into a field
Trying to have two columns that will capture the original date and
updated date after making a change to a row. I used this formula as a quick test and it populates the date but if any cell is changed on the spreadsheet the date is updated again - in cell A1 [ =IF(ISBLANK(B1),"blank",NOW()) ]. GOAL: on insert to the row - I'd like to populate both 'original date' and 'update date' and then when changes are made to that row - just modify the 'update date' cell. any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DCOUNT - date as a field only works when entered as a number | Excel Worksheet Functions | |||
| Sumproduct based on date entered in separate field | Excel Discussion (Misc queries) | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| Date Entered +7, unless another field is greater than 0 | Excel Worksheet Functions | |||
| New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
Threaded Mode
