Hi ALL,

Thank you for helping out with this formula. I have a set of unique ids and dates in x/xx/xxxx xx:xx:xx format. I would like to create a if formula that will send back a string labelled "new" in the status column if date is closest to today's date.

I am thinking if and max formula, but do not know how to.
Please see attachment
formulaifandmax.xlsx

Thank you,

Newb