How to know the absent dates of Employees in one cell

[Azhar Abbas]

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