how to get specific absent dates from employees attendance data

how to get specific absent dates from employees attendance data.CHECK EXAMPLE

Perhaps something like this? pls see the file attach

Regards
Azumi

Thanks you very much azumi boss. I got it

and i got that absent dates in coloum? ( ai ) only one coloum like that 01/05/2014,2/05/2014,3/05/2014 if possible plz help me

Yes in which column? sorry not clear about what you need

dear azumi .
in My example attendance IN last coloum ( AI) i need total "A"dates in this coloum (AI). like that
abt on 01/05/2014,05/05/2014,10/05/2014
its possible plz help me.

PLZ CHECK MY EXAMPLE ATTENDANCE SHEET

Put in Cell AI2 and copied down:

=COUNTIF(D2:AH2,"="&"A")

something like that?

dear azumi
THANKS FOR REPLY. BUT I NEED TO ABSENT DATES NOT TOTAL ABSENT

Ooops sorry, please see the file attach.....

Regards

dear azumi

thanks a lots for help me. you are really genius. its working thanks again.

Ah yes glad it works hehe...

best regards
Azumi

Hi,

Pls help me out in getting absent dates data from the below example:

Capture.JPGCapture.JPG

File Attached herewith.