How to find the Specific absent dates in attendance sheet.

[Pravin freddy Lazarus]

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.

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>

 

[ttray33y]

honestly, thats a horrible spreadsheet. piece of advice next time.
dont beautify your simple spreadsheet just like on your example its going to give you headache during data extraction or reports or slicing data.
create spreadsheet like what you see on pure database where you can only see headers and metadata below, and extract any data and report easily.