Nested if date less then equal today or blank

Hi and welcome to the forum

Try this array formula...
=MAX(IF(O2:R2<=TODAY(),O2:R2,0))
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

are your "Dates" actual dates or are they text....there is a function called ISDATE in 2007 and above and I don't remember if it is in 2003...if not....right click on the date cell and go to format and click general....it should come back as a number....like today is 41401....HTH

@ judge is you look at the sample file provided by the OP, you will see that they are real dates

Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

@FDibbins - thanks I didn't see the sample file....thanks for the heads up....

@ judge no problem