# monthly split of contract value

1. ## monthly split of contract value

Hi All,

I was able to come up with below formula for splitting contract value into months for revenue based on start and end date of the contract.
``Please Login or Register  to view this content.``
D7 = start Date
E7 = end date
G6 = beg of current month
H7 = end of current month (ie beg of next month)
F7 = annaul contract value.

This formula works perfectly for 365 days calculation, i want to make it into 360 days calculation, so that revenue amount is same for all the months.

I have attached the file.

Thks

Nazim

2. ## Re: monthly split of contract value

Hi,

It's not clear, at least to me, exactly what you're asking for. If you want the revenue the same for each month then why not just divide F7 by 12.

Using a divisor of 360 when you're using dates which cover 365 days are always going to result in a difference.

Regards

3. ## Re: monthly split of contract value

divinding by 12 will not work firstly it only works when dates are matching (manual excercise) and secondly contract date can start from the mid of the month. i am looking for function like days360 which convert 365 days into 360 days.

4. ## Re: monthly split of contract value

Hi,

It's still not clear. Please indicate what values you expect to see each month and maybe we can then come up with a formulaic solution.

Rgds

5. ## Re: monthly split of contract value

it should by 1000 every month

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