View Single Post
 
Old 05-11-2020, 04:28 PM
swethra swethra is offline Windows 10 Office 2019
Novice
 
Join Date: May 2020
Posts: 1
swethra is on a distinguished road
Default 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?
Reply With Quote