=SUMPRODUCT(--(A1:A20=DATE(YEAR(H1)-1,MONTH(H1),1)),B1:B20)

where H1 is the date you want to compare against, it can be any date in the
month.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"splodgey" wrote in message
...
Hi does anyone know if there is a way to calculate how many days a person
has
taken off over a running tweleve month period? For example If a person
was
off:

2 Days May 06
3 Days December 06
10 April 07

In May the running total would be 15 days, however at the end of June the
total would only be 13.

Any ideas would be much appreciated