Retrieve a date in Google Sheets
gaelgael228
Posted messages
26
Status
Member
-
Anonymous user -
Anonymous user -
Hello,
In my spreadsheet, I align dates one after the other (in rows and in ascending order).
I would like to access the most recent date (the one furthest to the right) without having to scroll through the spreadsheet.
In short, I want to retrieve the most recent date and display it in a cell at the beginning of the spreadsheet (always the same one).
Do you know how to do this?
I am a beginner in this area.
Thank you
Configuration: Windows / Chrome 95.0.4638.54
In my spreadsheet, I align dates one after the other (in rows and in ascending order).
I would like to access the most recent date (the one furthest to the right) without having to scroll through the spreadsheet.
In short, I want to retrieve the most recent date and display it in a cell at the beginning of the spreadsheet (always the same one).
Do you know how to do this?
I am a beginner in this area.
Thank you
Configuration: Windows / Chrome 95.0.4638.54
5 answers
Hello, yes, with pleasure.
here it is https://docs.google.com/spreadsheets/d/1if7yZfznu_OhAfbyvuQsOMo75J1RdMifLlF3XTfVF5M/edit?usp=sharing
I deleted all data from the document except for the relevant columns, namely:
column P which retrieves data from columns AK to AP
As you will see, the formula works well, but when there is no date on the row of the formula, I get returned an absurd date.
here it is https://docs.google.com/spreadsheets/d/1if7yZfznu_OhAfbyvuQsOMo75J1RdMifLlF3XTfVF5M/edit?usp=sharing
I deleted all data from the document except for the relevant columns, namely:
column P which retrieves data from columns AK to AP
As you will see, the formula works well, but when there is no date on the row of the formula, I get returned an absurd date.
Oops sorry,
I think it's good now
https://docs.google.com/spreadsheets/d/1if7yZfznu_OhAfbyvuQsOMo75J1RdMifLlF3XTfVF5M/edit?usp=sharing
I think it's good now
https://docs.google.com/spreadsheets/d/1if7yZfznu_OhAfbyvuQsOMo75J1RdMifLlF3XTfVF5M/edit?usp=sharing
No worries :-) It's readable now.
Using formulas in Sheets infrequently, I don’t understand where the problem comes from.
To work around this, I suggest using the formula =IF(max(a_range)>DATEVALUE("01/01/1980"),max(a_range),"") (see column O of your sheet).
Maybe someone will suggest something better!
Best regards
Using formulas in Sheets infrequently, I don’t understand where the problem comes from.
To work around this, I suggest using the formula =IF(max(a_range)>DATEVALUE("01/01/1980"),max(a_range),"") (see column O of your sheet).
Maybe someone will suggest something better!
Best regards