Select Most Recent Date In List

S.Stone

Hello!

I need a formula to pull the most recent date in a list, but I keep getting unparsable and invalid errors.

Could someone please help me create a formula to put in the highlighted cell?

Please note there are empty dates (like the top row). This sheet is driven by a form, so new dates may be added out of order - in case any of this affects the formula.

Thank you!

VBAGuru

If you make the Date and Most Recent Date columns into date format you can use

=MAX(COLLECT(Date:Date, Date:Date, <>""))

VBAGuru

If you make the Date and Most Recent Date columns into date format you can use

=MAX(COLLECT(Date:Date, Date:Date, <>""))

S.Stone

@VBAGuru Beautiful, thank you!

I just needed to change the column type - so simple!

I appreciate you!

VBAGuru

Glad I could help!