EDate Formula Issue?

[ptmuldoon]

I had gotten some help in the past, and have a formula that will summarize the sales for XX months depending on the month being chosen, and the number of months desired.

I had thought that everything was working correctly till today. Now, I have learned that when the user enters the month of November, my 3 and 6 month summaries are actually adding up 4 and 5 months. However, it does compute accurately for 9 and 12 month totals.

However, this seems to add incorrectly only if choosing to compare the month of November. If you change the compare date to any month, everything seems correct.

Sample attached. And hoping someone can see if anything looks incorrect?

Thanks
PT

[Haseeb Avarakkan]

In column b you have used EOMONTH, so date will be end of the each month.

">"&EDATE(H15,-3) is ">"&30-Aug-2014, which is including 31-Aug-2014, Aug-14, Sep-14, Oct-14, Nov-14

So use EOMONTH instead of EDATE in your formulas

[Ron Coderre]

Using your posted workbook,
this formula, copied across and down, returns the period summaries

Please Login or Register  to view this content.

Is that something you can work with?