|
|
#7
01-08-2018, 01:16 PM
|
|||
|
|||
Quote:
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Revenue REcognition for Leasing business
|
sshetty | Excel Programming | 1 | 05-11-2015 01:42 AM |
| Excel Formula Showing Revenue Recognition Based on Days and Months | stratcat | Excel | 4 | 03-16-2014 10:09 AM |
| Deferred delivery error | norma22 | Outlook | 0 | 11-21-2005 06:47 PM |
Windows 8 
Office 2010 32bit
Threaded Mode