Rolling Year

[Tim Halpin (BV)]

I am currently using the formula =SUMIF(Master!$A6:$A1466,">=" &
DATE(YEAR(TODAY())-1,MONTH(TODAY()),1),Master!B6:B1466) to calculate figures
for the previous rolling year. However the issue i am having is that it seems
to be rounding to each month rather than daily as i require, i presume this
is due to the fact that there is Month in the formula, i have tried using Day
instead but have had no joy.

Can anyone help?

Thanks

 

[Joel]

the last 1 in the DATE functtion is comparing againstt the 1stt of the month.
to make it daily try
=SUMIF(Master!$A6:$A1466,">=" &
DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),Master!B6:B1466)

You may need to adjust by one day. If today is March 5th do you want
March 5 2006 to March 4 2007 or March 6 2006 to March 5 2007, or March 5
2006 to March 5 2007

 

[Bob Phillips]

=SUMIF(Master!$A6:$A1466,">="
&DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),Master!B6:B1466)

--
---
HTH

Bob

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