Rolling Year
 

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

Rolling Year
 

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


"Tim Halpin (BV)" wrote:

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

Rolling Year
 

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



"Tim Halpin (BV)" wrote in message
...
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