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