Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2020, 04:28 PM
swethra swethra is offline Help with Excel formula for sale distribution Windows 10 Help with Excel formula for sale distribution Office 2019
Novice
Help with Excel formula for sale distribution
 
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
  #2  
Old 05-12-2020, 09:04 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with Excel formula for sale distribution Windows 7 64bit Help with Excel formula for sale distribution Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,411
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Hi
a sheet (no pics) with some data and expected results added manually would make things clearer
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Excel formula for sale distribution 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
Help with Excel formula for sale distribution Excel Formula ctruggles Excel 1 12-05-2016 12:12 PM
Help with Excel formula for sale distribution ** Excel Formula djreyrey Excel 8 04-15-2011 03:55 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft