Azhar Abbas
New Member
- Joined
- Feb 28, 2019
- Messages
- 1
Employee Code | Employee Name | 1-Jan | 2-Jan | 3-Jan | 4-Jan | 5-Jan | 6-Jan | 7-Jan | 8-Jan | 9-Jan | 10-Jan | 11-Jan | 12-Jan | 13-Jan | 14-Jan | 15-Jan | 16-Jan | 17-Jan | 18-Jan | 19-Jan | 20-Jan | 21-Jan | 22-Jan | 23-Jan | 24-Jan | 25-Jan | 26-Jan | 27-Jan | 28-Jan | 29-Jan | 30-Jan | 31/01/2018 |
1 | A | - | 1 | - | - | - | W | - | - | - | - | - | - | W | - | - | A | 1 | - | - | W | 2 | A | - | - | - | - | W | - | - | - | - |
2 | B | - | - | - | - | A | W | - | - | - | - | - | - | W | - | - | - | - | - | - | W | - | - | - | - | - | - | W | - | - | - | - |
3 | C | - | - | A | - | - | W | A | A | A | A | A | A | W | - | - | - | - | - | - | W | A | A | - | - | - | - | W | - | - | - | - |
4 | D | - | - | - | - | 1 | W | - | - | - | - | - | - | W | - | - | - | - | - | 1 | W | - | - | - | - | 1 | 1 | W | - | - | - | 1 |
5 | Ee | - | - | - | - | A | W | A | A | A | A | A | A | W | - | - | - | - | A | - | W | - | - | - | - | - | - | W | A | - | - | - |
6 | H | - | A | - | - | - | W | - | - | - | - | - | - | W | - | - | - | - | - | - | W | - | - | - | - | - | - | W | - | - | - | - |
<colgroup><col><col><col span="3"><col><col span="5"><col span="21"><col></colgroup><tbody>
</tbody>
I need Absent dates from employee attendance in Last row. Please Provide solution in Excel with out Micr.
A Col E. Name, B Col Name , C -D-E ... date of Months "A" shows Absent in sheet