cannot get formula to calculate correcly

[Icarium20]

Hello All

first post so hope all okay. Tell me if not and I change whats needed.

 I have the following formula which should be adding figures from one sheet dependent upon the header and date, and inserting the monthly total onto another sheet under the month and correct header, except its not. From what I can evaluate its also adding the next months figure (doing April, would add May's accumulative Total to Aprils} also. I'm unable to work out why so am asking if anyone can see whats wrong firstly.  many thanks

[#2 · Accepted solution]

@Icarium20  The problem is with EOMONTH($B5,1).  Use EOMONTH($B5,0) instead.  The second value is how many months to offset so 1 means give the end of the month date for the month 1 month after this date.  0 means this B5 month.

Best of luck.

[#3]

Thank you mtarler.

That works exactly as you said. Can now proceed to work out the Tax im due to pay, Doh

Again thanks