# Split the equal amount acoss months based on start and end date

1. ## Split the equal amount acoss months based on start and end date

Hello Everyone,

I have contarct for amount \$5000 with a start date of 1/1/2014 - 3/31/2014 (3 months). I would like to equally split my amount based on my number of months between 1/1/2014 and 3/31/2014 ie \$1666.66/per month.

Any thoughts recommendation ?

Thank you everyone.

2. ## Re: Split the equal amount acoss months based on start and end date

Hi and welcome to the forum

Assuming your data is laid out like this...

 A B C D 1 5000 1/1/2014 3/31/2014 1666.667

D1=A1/(MONTH(C1)-MONTH(B1)+1)

3. ## Re: Split the equal amount acoss months based on start and end date

This version will account for dates that may span multiple years.

A2 = 5000
B2 = start date
C2 = end date

=A2/(DATEDIF(B2-DAY(B2)+1,C2,"m")+1)

4. ## Re: Split the equal amount acoss months based on start and end date

Hello Everyone,

Thank you for your response, but I should see my amounts only for month Jan, Feb and March given my start and end date is 1/1/2014 - 3/31/2014. I have attached a sample of data. Can you suggest any workarounds ?

Thanks

5. ## Re: Split the equal amount acoss months based on start and end date

Will the date range always be within the same year?

Since there are only 12 months as the column headers I assume that will be the case?

#### Thread Information

##### Users Browsing this Thread

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