#1
|
|||
|
|||
Help with Excel formula for sale distribution
Hi Experts, Need your help with distributing sales based on the date range.
For example - I want to distribute my contract value based on the contract start and end date as well as the period start and end date. for eg if my period start and end date is 5th jan and 30th Jan and my contract starts at 27th Jan then its only 4 days of allocation I want in month one. For month2 i would allocate the contract value based on my period start and end date. Can you help with a formula for this? |
#2
|
||||
|
||||
Hi
a sheet (no pics) with some data and expected results added manually would make things clearer
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel no formula bar | otuatail | Excel | 4 | 03-05-2019 04:31 AM |
Software for sale | billcorb | Forum Support | 1 | 08-13-2017 01:40 PM |
Excel Formula - Help | guiverdi | Excel | 2 | 07-23-2017 11:48 PM |
Excel Formula | ctruggles | Excel | 1 | 12-05-2016 12:12 PM |
** Excel Formula | djreyrey | Excel | 8 | 04-15-2011 03:55 PM |