How to count employes absent dates in excel 2007

[dineshjangir]

I HAVE EMPLOYS MASTROL ROLL AND I NEED TO ONE FORMULA I CAN GET ABSENT DATES IN ONE CELL IN EXCEL. HOW TO GET PLZ HELP ME .

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

AE

AF

AG

AH

AI

STAFF ID

NAME

DESIGNATION

1-May-14

2-May-14

3-May-14

4-May-14

5-May-14

6-May-14

7-May-14

8-May-14

9-May-14

10-May-14

11-May-14

12-May-14

13-May-14

14-May-14

15-May-14

16-May-14

17-May-14

18-May-14

19-May-14

20-May-14

21-May-14

22-May-14

23-May-14

24-May-14

25-May-14

26-May-14

27-May-14

28-May-14

29-May-14

30-May-14

31-May-14

ABSENT DATES

1

D

ELEC

P

P

P

F

P

P

P

P

P

P

F

A

P

P

P

P

P

F

P

P

P

P

P

P

F

P

P

A

P

P

P

2

R

ELEC

P

A

A

F

P

A

P

P

P

P

F

P

P

P

P

P

P

F

P

P

A

P

P

P

F

A

P

P

A

P

P

3

B

ELEC

P

P

A

F

P

P

P

A

P

P

F

A

P

P

P

P

P

F

P

P

P

P

P

P

F

P

P

P

A

P

P

4

V

ELEC

P

P

P

F

P

P

P

P

P

P

F

P

P

P

P

P

P

F

P

P

P

A

P

P

F

A

P

P

P

P

P

<tbody>
</tbody>

 

[mole999]

have a read of http://www.mrexcel.com/forum/excel-questions/781394-spilt-date-range-into-one-row-per-day.html

 

[markmzz]

Maybe this:

In AI2

=COUNTIF($D$2:$AH$2,"A")

Markmzz

 

[dineshjangir]

dear markmzz
thanks for reply
i need to dates not how many days absent.if you have any formula i can get dates which date employer "A" PLZ SEND ME

 

[markmzz]

dear markmzz
thanks for reply
i need to dates not how many days absent.if you have any formula i can get dates which date employer "A" PLZ SEND ME

You are welcome.

Sorry, but I didn't understand what you want.

Could you post the result that you want in your first post and why?

Markmzz