Date search and return?

Mandi

Is there a formula to search a row of dates and return the latest in a column?

Genevieve P.

Hi @Mandi ,

Yes! The MAX Function (see here) will return the highest date, or the newest/most "future" date.

Alternately, the MIN Function (see here) will return the lowest date, or the date furthest in the past.

If you need help using this, it would be helpful to see a screen capture of your sheet with an explanation of what you're looking to do (but please block out any sensitive data).

Cheers,

Genevieve

Genevieve P.

Hi @Mandi ,

Yes! The MAX Function (see here) will return the highest date, or the newest/most "future" date.

Alternately, the MIN Function (see here) will return the lowest date, or the date furthest in the past.

If you need help using this, it would be helpful to see a screen capture of your sheet with an explanation of what you're looking to do (but please block out any sensitive data).

Cheers,

Genevieve

Mandi

Thanks Genevieve, this is exactly what I was looking for.  Easy to implement.

Regards, Mandi

Genevieve P.

That's great to hear! I'm glad it worked for you. 🙂