Find latest day number in month.

[RockandGrohl]

Sorry guys, my google-fu is failing because it keeps thinking I want to either find the last day of the month, etc.

Anyway, in column A I have a list of dates, 01/01/2023, 03/01/2023, 05/01/2023, 06/01/2023..

How do I return "6" - as in, 6 is the last day of that string of dates.

I could do this - is there a more elegant way?

=MAX(CDR!A:A)-DATE(YEAR(CDR!A2),MONTH(CDR!A2),1)

Thanks!

 

[Fluff]

How about

=day(MAX(CDR!A:A))

 

[davesexcel]

To get largest date in a range.

=LARGE(E1:E15,1)