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?
|