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.
Bookmarks