What version of Excel are you using? 2007 or 2010?
Personally, what I'd do with it is to group the dates by year and by month, add a subtotal to the year, and avoid the calculated fields all together. Then use a filter to exclue the dates after the month that you want. Way easier to set up, and you only need to refresh the filter each time the month changes.
Bookmarks