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 .


[TABLE="width: 1087"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[TD]O
[/TD]
[TD]P
[/TD]
[TD]Q
[/TD]
[TD]R
[/TD]
[TD]S
[/TD]
[TD]T
[/TD]
[TD]U
[/TD]
[TD]V
[/TD]
[TD]W
[/TD]
[TD]X
[/TD]
[TD]Y
[/TD]
[TD]Z
[/TD]
[TD]AA
[/TD]
[TD]AB
[/TD]
[TD]AC
[/TD]
[TD]AD
[/TD]
[TD]AE
[/TD]
[TD]AF
[/TD]
[TD]AG
[/TD]
[TD]AH
[/TD]
[TD]AI
[/TD]
[/TR]
[TR]
[TD]STAFF ID
[/TD]
[TD]NAME
[/TD]
[TD]DESIGNATION
[/TD]
[TD]1-May-14
[/TD]
[TD]2-May-14
[/TD]
[TD]3-May-14
[/TD]
[TD]4-May-14
[/TD]
[TD]5-May-14
[/TD]
[TD]6-May-14
[/TD]
[TD]7-May-14
[/TD]
[TD]8-May-14
[/TD]
[TD]9-May-14
[/TD]
[TD]10-May-14
[/TD]
[TD]11-May-14
[/TD]
[TD]12-May-14
[/TD]
[TD]13-May-14
[/TD]
[TD]14-May-14
[/TD]
[TD]15-May-14
[/TD]
[TD]16-May-14
[/TD]
[TD]17-May-14
[/TD]
[TD]18-May-14
[/TD]
[TD]19-May-14
[/TD]
[TD]20-May-14
[/TD]
[TD]21-May-14
[/TD]
[TD]22-May-14
[/TD]
[TD]23-May-14
[/TD]
[TD]24-May-14
[/TD]
[TD]25-May-14
[/TD]
[TD]26-May-14
[/TD]
[TD]27-May-14
[/TD]
[TD]28-May-14
[/TD]
[TD]29-May-14
[/TD]
[TD]30-May-14
[/TD]
[TD]31-May-14
[/TD]
[TD]ABSENT DATES
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]D
[/TD]
[TD]ELEC
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]R
[/TD]
[TD]ELEC
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]A
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]B
[/TD]
[TD]ELEC
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]V
[/TD]
[TD]ELEC
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]F
[/TD]
[TD]A
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]P
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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