Number of days in a running period
 

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

Number of days in a running period
 

=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