how to get specific absent dates from employees attendance data

dear all,

i have 1 problem in employes master toll
i want to absent dates in last coloum plz help me
in master rool
a= staff id, b=name,c=designation,d=star dates,ah=end dates
like that
D E F G AH
1/05/2014 02/05/2014 03/05/2014 04/05/2014 CONTINUE DATES END DATES 31/05/2014
p p A A A

I WANT FORMULA HOW TO COUNT ABSENT DATES
PLEASE HELP ME

Hi,

Please post a sample template of your workbook, this can be done using COUNTIF.