Simplify an IF function

I have been working on a work schedule that locates the last work over date (over time) on an employee schedule. In column I it lists the last work over, but it cannot be today or in the future. So if the employee is scheduled next week it cannot show that date. I developed this IF function to return a date for that criteria. I will probably have to go back further than 3 months to capture the last work over, so the function gets longer.

=IF(MAX(E4:H4)<TODAY(),MAX(E4:H4),IF(MAX(E4:G4)<TODAY(),MAX(E4:G4),IF(MAX(E4:F4)<TODAY(),MAX(E4:F4),MAX(E4:F4))))

Any ideas on making it shorter would be appreciated.

If you read this Haseeb, thanks again for the function that allows it to query the prior months.

Try this,

I4, copy down.

=IFERROR(SMALL(E4:H4,COUNTIF(E4:H4,"<="&TODAY())),"")

Note: TODAY() is a volatile function, so the file will calculate if anything changes on in any open workbook. Enter TODAY() in a cell some where then reference that cells in the formula instead of using multiple times.