Pravin freddy Lazarus
New Member
- Joined
- Jul 25, 2017
- Messages
- 1
Dear Guys,
Hi......
I Need formula to know find the specific date of absent in one cell for an employee...
Kindly advice me...
Note:
A-Absent
P-Present
WO-Week-off
Waiting for your soon reply.
I given below my attendance sheet format.
Kindly Update.
<colgroup><col><col><col><col><col><col><col span="3"><col><col span="29"><col><col span="2"><col span="4"><col></colgroup><tbody>
</tbody>
Hi......
I Need formula to know find the specific date of absent in one cell for an employee...
Kindly advice me...
Note:
A-Absent
P-Present
WO-Week-off
Waiting for your soon reply.
I given below my attendance sheet format.
Kindly Update.
ATTENDANCE DETAILS | ||||||||||||||||||||||||||||||||||||||||||||||
S.No | Employee ID | Name of the person Employed | Existing | D.O.J (Actual) | Date of Confirmation | Service | 26-Jan | 27-Jun | 28-Jun | 29-Jun | 30-Jun | 1-Jul | 2-Jul | 3-Jul | 4-Jul | 5-Jul | 6-Jul | 7-Jul | 8-Jul | 9-Jul | 10-Jul | 11-Jul | 12-Jul | 13-Jul | 14-Jul | 15-Jul | 16-Jul | 17-Jul | 18-Jul | 19-Jul | 20-Jul | 21-Jul | 22-Jul | 23-Jul | 24-Jul | 25-Jul | No. Absent Dates | TOTAL | Total Mandays | |||||||
Years | Months | Days | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | PRESENT | ABSENT | "WO" | FH | NH | Total HD | ||||||||
Accounts | Adyar- Accounts | |||||||||||||||||||||||||||||||||||||||||||||
1 | KUN0569 | M.Pratheep | Accounts Assistant | 14-09-2014 | 01-12-2014 | 2 | 7 | 24 | P | P | P | P | P | P | WO | P | A | P | P | P | P | WO | P | P | A | P | P | P | WO | P | P | P | P | P | P | WO | P | P | 24 | 2 | 4 | 0 | 0 | 0 | 30 | |
2 | KUN0588 | A.Srilekha | Accounts Assistant | 16-02-2015 | 01-04-2015 | 2 | 3 | 24 | P | P | P | P | P | P | WO | P | P | P | P | A | P | WO | P | P | P | P | P | P | WO | P | P | P | P | A | P | WO | P | P | 24 | 2 | 4 | 0 | 0 | 0 | 30 | |
3 | KUN0697 | K.Chandrasekaran | Sr.Accounts Executive | 21-03-2016 | 01-04-2016 | 1 | 3 | 24 | P | P | P | P | P | P | WO | A | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | A | P | 24 | 2 | 4 | 0 | 0 | 0 | 30 |
<colgroup><col><col><col><col><col><col><col span="3"><col><col span="29"><col><col span="2"><col span="4"><col></colgroup><tbody>
</tbody>