I need to quickly compare two dates to determine which is the latest of the two dates to develop an I-9 destruction template...any thoughts?



I'm comparing:

• Hire date plus 3 years; to
• Term date plus 1 year

Thank you!

Try = MAX (Hire date plus 3 years,Term date plus 1 year)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks! This worked perfectly!