Results 1 to 4 of 4

Calculate the portion of a planned number during a period, based on another time period

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2016
    Location
    Los Angeles
    MS-Off Ver
    2014
    Posts
    15

    Calculate the portion of a planned number during a period, based on another time period

    I have "things" which should deliver a planned amount evenly over a start and end date. I am trying to use a weekly report date (which will change week to week) to calculate how many of those "things" should have been delivered over that time period.

    I figured out how to make it work if the weekly reporting period is completely outside/inside the time period, but cannot if only a few days fall into the star and end date.

    How can I calculate the number of days one date range overlaps another?
    Attached Files Attached Files
    Last edited by BryGuy81; 04-19-2017 at 01:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pivot Table : Planned and Actual Count Over Same Time Period
    By chullan88 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 02-11-2016, 12:44 AM
  2. [SOLVED] Calculate values based on time period
    By rtcwlomax in forum Excel Programming / VBA / Macros
    Replies: 58
    Last Post: 06-30-2015, 05:58 PM
  3. Calculate Time Period -
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2014, 11:11 AM
  4. Replies: 1
    Last Post: 04-24-2013, 11:38 PM
  5. Replies: 30
    Last Post: 11-14-2012, 09:39 AM
  6. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  7. Replies: 8
    Last Post: 02-23-2005, 06:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1