Find months between start and end dates and multiple the monthly revenue

[Vinnie Chan]

Hi,

I have problem calculating the revenue. From Row 33 to 46 has no problem. But in Row 48, the revenue of the last year is correct, but every year before that would add one month revenue to the total, i.e., monthly revenue x 13 months, but it should be x 12 months.

Can anyone help me to look at this please?

Thank you.

[Tsjallie]

I believe the problem is in this line of code:

Please Login or Register  to view this content.

I think that's giving the first day of the next month iso the last day of the current month.
In this way it's calculating the number of months between for instance 1-10-2012 and 1-10-2013 which gives 13. So date2 should be 30-9-2013.

Because my Excel version (Dutch) doesn't like the eomonth-thing, I altered this line in:

Please Login or Register  to view this content.

On the other hand, we not just multiply be 12 iso calculating the number months?