Forum Discussion
Date of Last Modified for a Cell
Good day, all. I am inquiring if there is an excel function that would give me a date (and time) that an individual cell was last modified. For example: cell A2 has an entry of $2.55 and I'd lik...
Hi Hans!
Thank you for this very useful and simple solution.
Unfortunately, the format is not working very well.
The "year" can only show "yy", not the year numbers.
And it's showing a way off date here (today 01/17/2023) but it reads "21/12/yy at 12:00 am" - now 11:21 am
Do you have any idea why it can figure out the right date or time?
Thank you very much in advance!
The format code yy works for the English language version of Excel.
If your version uses another language, you probably have to use another letter.
For example, for French, Spanish, Italian and Portuguese it would be aa (for année, año, anno, ano), and in German and Dutch it would be jj (for Jahr, jaar), etc.
- Thank you very much!