AABID QURESHI
New Member
- Joined
- Dec 6, 2020
- Messages
- 20
- Office Version
- 2010
- Platform
- Windows
Hi this is Aabid here.
I need a formula which returns me start and end date of Leave, Absent and likely to be given values.
Suppose an employee is on leave from 08 to 17, it is marked in sheet, then it should return first start date and end date.
Please help about it.
I need a formula which returns me start and end date of Leave, Absent and likely to be given values.
Suppose an employee is on leave from 08 to 17, it is marked in sheet, then it should return first start date and end date.
Please help about it.
S. No. | Employee CPe | Employee Name | Designation | Department | Date Joined | 01-12-2020 | 02-12-2020 | 03-12-2020 | 04-12-2020 | 05-12-2020 | 06-12-2020 | 07-12-2020 | 08-12-2020 | 09-12-2020 | 10-12-2020 | 11-12-2020 | 12-12-2020 | 13-12-2020 | 14-12-2020 | 15-12-2020 | 16-12-2020 | 17-12-2020 | 18-12-2020 | 19-12-2020 | 20-12-2020 | 21-12-2020 | 22-12-2020 | 23-12-2020 | 24-12-2020 | 25-12-2020 | 26-12-2020 | 27-12-2020 | 28-12-2020 | 29-12-2020 | 30-12-2020 | FROM | TO |
1 | 242 | MAHAVEER SINGH NATHWAT | SR. FOREMAN | PLANT & EQUIPMENTS | 19-03-2006 | W | P | P | P | P | OD | OD | OD | OD | OD | OD | P | P | H | H | A | A | P | P | P | P | W | P | P | P | P | P | P | P | P | ||
2 | 448 | ARVIND KUMAR | CONSTRUCATION MANAGER | HIGHWAY | 01-08-2007 | W | P | P | P | P | P | P | W | P | P | P | P | EL | H | H | P | P | P | P | P | P | W | P | P | P | P | P | P | P | P | ||
3 | 787 | RAJESH SINGAL | PROJECT COORDINATOR | OPERATION | 25-04-2008 | W | P | P | P | P | P | P | EL | EL | EL | EL | EL | EL | H | H | EL | EL | P | P | P | P | W | P | P | P | P | P | P | P | P | ||
4 | 1489 | ASHOK PRASAD SINGH | FOREMAN | HIGHWAY | 15-02-2010 | W | P | P | P | P | P | P | W | P | P | P | P | P | H | H | P | P | P | P | P | P | W | P | P | P | P | P | P | P | P |