View Single Post
 
Old 01-08-2018, 01:16 PM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
 
Join Date: Mar 2015
Posts: 79
Haha88 is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
For me also remained unclear, what you want to calculate, but I tried to quess
Thank you.
What I really need is: month end = 28/02/17
1. In Feb column, the income is calculate from contract starts date to end of feb
2.if the contract is 12 mths, the next 10 mths = contract total value/12*1
3.column for month 12th = total contract value - total sum of all previous months

Will this be any more clear?
Reply With Quote