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

1. ## Find months between start and end dates and multiple the monthly revenue

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.

2. ## Re: Find months between start and end dates and multiple the monthly revenue

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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1