Return the latest date from a list of dates

[davidp]

 

[Guest]

with your list of dates in A1:A100
=MAX(A1:A100)

Cheers
JulieD

 

[davidp]

thanks. sometimes its right in front of you!

-----Original Message-----
with your list of dates in A1:A100
=MAX(A1:A100)

Cheers
JulieD


.

 

[john.bedford3]

How would you adapt this if you wanted to find the latest date in a
particular month from a list of dates?

 

[CLR]

Assuming your dates are in column A, and the number of the month you wish to
call up is in C1........
put this in B1 and copy down.... =IF(MONTH(A1)=$C$1,A1,"")

then in D1 put this....... =MAX(B:B)

Vaya con Dios,
Chuck, CABGx3

 

[Ron Rosenfeld]

How would you adapt this if you wanted to find the latest date in a
particular month from a list of dates?

Assume:

Dates: named range including all your dates. Can be in any order.
Month: named range (cell) containing the month number (1=Jan)

Array formula:

=MAX((MONTH(Dates)=Month)*Dates)

To enter an array formula, you must hold down <ctrl><shift> while hitting
<enter>. XL will place braces {...} around the formula.


--ron

 

[john.bedford3]

Thanks, I will keep a note of this for future reference. Ron's method suits
my spreadsheet better in this case.

John

 

[john.bedford3]

Thanks Ron that has solved another problem for me.

John

 

[Ron Rosenfeld]

Thanks Ron that has solved another problem for me.

John

Glad to help. Thank you for the feedback.


--ron