Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I determine the modification date of a cell?
I'm creating a prioritized list using Excel 2003 that will be updated
periodically. I would like to know if there is a way to capture the last date when a priority was changed. For example, if A1 contains a priority of level 1, then B1 would contain the date of when I entered that priority. Now, let's say after a few weeks that priority is changed to level 2, I now want B2 to show the new date of when the change to 2 was made. Any ideas on how to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for last modification date? | Excel Discussion (Misc queries) | |||
Modification Date | Excel Discussion (Misc queries) | |||
Determine next Saturday in calendar based on date in a cell | New Users to Excel | |||
Last Modification Date | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |