Use formula to find oldest date in row



I have a row with several expiration dates in different columns. I’d like a cell to calculate which of these dates in the row is next date to Expire. I’ve tried MIN() but it doesn’t recognise date values.

Any suggestions?



Use nested IF statements to create an IF/ELSE/ELSE along with the DATETIME_DIFF() and TODAY() or NOW() methods.

IF (
"First field is greatest",
IF (
"Second field is greatest",
"Third field is greatest"


It’s not working. I can’t even get the cell to show if the date is < or > than today in a standard IF formula.

I am using LOCAL date format.


I’ve changed it a little and now calculating the months and using MIN so it is working now.

Thanks for the response.