# Identify MAX Date for each employee

✭✭✭✭

I have created a list that tracks the number of days an employee is out. I need to identify the most recent absence. An employee can be on the list more than once. I would like to use the MAX function to identify the most recent absence for each employee by checking the box in Max Date. Is there a way to do that?

The unique identifier is the Emp Id.

Tags:

• ✭✭✭✭✭✭

You can absolutely do this:

=IF(MAX(COLLECT([Leave End]:[Leave End], [Emp ID]:[Emp ID], [Emp ID]@row)) = [Leave End]@row, 1, 0)

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

• ✭✭✭✭✭✭

You can absolutely do this:

=IF(MAX(COLLECT([Leave End]:[Leave End], [Emp ID]:[Emp ID], [Emp ID]@row)) = [Leave End]@row, 1, 0)

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

• ✭✭✭✭

Works perfectly!

Thank you.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!