Rob_010101
Board Regular
- Joined
- Jul 24, 2017
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
Hello
I'll try and keep this simple.
Sheet 1
This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row.
On each occasion, there is an absence start date and an absence end date.
Example: an employee with 2 separate occasions will have 2 rows each containing the absence start and absence end.
Sheet 2
On this sheet, I would like to use a formula in column L to find the last day of absence for each employee from sheet 1
If it helps, employee ID (unique record) is included in column A to reference.
So, in column L on the above, it would say 30/03/2022 because that is the latest absence end date.
I hope this makes sense.
Kind Regards
Chris
I'll try and keep this simple.
Sheet 1
This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row.
On each occasion, there is an absence start date and an absence end date.
Example: an employee with 2 separate occasions will have 2 rows each containing the absence start and absence end.
Sheet 2
On this sheet, I would like to use a formula in column L to find the last day of absence for each employee from sheet 1
If it helps, employee ID (unique record) is included in column A to reference.
So, in column L on the above, it would say 30/03/2022 because that is the latest absence end date.
I hope this makes sense.
Kind Regards
Chris
