Number of days in a running period

[splodgey]

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

 

[Bob Phillips]

=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)