Extract Date based on Dynamic Date

[Steve 1962]

HI
I am attempting to obtain the latest date (to be shown in cell B9) from a list of dates. Example –

Today is 20/8/24 (cell B8 which will have the formula =Today()) however I require the latest date in column A2 to A6 which in this case is 15 Aug (cell A3) to be shown in cell B9.
Based on today’s date which will be dynamic with “=TODAY()”, I want the latest date extracted from cells A2 to A6.

Thanks

Book1
	A	B
1	Date
2	14/08/2024
3	15/08/2024
4	21/08/2024
5	24/08/2024
6	29/08/2024
7
8	Today =	20/08/2024
9	Date Required =	15/08/2024
Sheet1

 

[Phuoc]

Try this:

=MAXIFS(A2:A6,A2:A6,"<="&B8)

 

[Steve 1962]

Hey thanks Phuoc. Works fine.

Have a good week.