How to know the absent dates of Employees in one cell

Azhar Abbas

New Member
Joined
Feb 28, 2019
Messages
1
Employee
Code
Employee
Name
1-Jan2-Jan3-Jan4-Jan5-Jan6-Jan7-Jan8-Jan9-Jan10-Jan11-Jan12-Jan13-Jan14-Jan15-Jan16-Jan17-Jan18-Jan19-Jan20-Jan21-Jan22-Jan23-Jan24-Jan25-Jan26-Jan27-Jan28-Jan29-Jan30-Jan31/01/2018
1A-1---W------W--A1--W2A----W----
2B----AW------W------W------W----
3C--A--WAAAAAAW------WAA----W----
4D ----1W------W-----1W----11W---1
5Ee ----AWAAAAAAW----A-W------WA---
6H-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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,108,808
Messages
5,524,995
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top