Populating Cell with the most recent change date on the sheet.

Scott Boehland

Hello- I am trying to have a cell populate with the date and time of the most recent activity on the sheet.

Zachary Hall

The easiest way would be to have a column (hidden if you like) with the Modified Date, and then in the cell you want to show the most recent activity have:

• =MAX([Modified Date]:[Modified Date])

Scott Boehland

I have tried that, when i paste the formula it is not working.

Genevieve P.

Hey @Scott Boehland

If you're not putting the formula in a Date type of column, you'll need to turn the Date into Text so it can be housed in that column.

=MAX([Modified Date]:[Modified Date]) + ""

Cheers,

Genevieve