Results 1 to 5 of 5

Calculating summed Value against 2 sets of date range Criteria

Threaded View

  1. 04-08-2015, 11:05 PM #1
    hamish100
    hamish100 is offline
    Registered User
    Join Date
    07-07-2012
    Location
    Pennslyvania, usa
    MS-Off Ver
    Excel 2010
    Posts
    13

    Calculating summed Value against 2 sets of date range Criteria

    Vacation Time.xlsx
    Vacation time.JPG

    Looking to calculate the sum of vacation days per month against a date range criteria.Formula will need the account for the assignment of right allocation of days between date ranges which start on one month and finish on another.
    Attached Images Attached Images
    Last edited by hamish100; 04-08-2015 at 11:11 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating # Late Last Week from multiple dates/date sets
    By jtmoore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2014, 01:20 PM
  2. [SOLVED] Need help with function calculating networkdays between two date sets
    By malarkeymaker in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-10-2013, 09:17 AM
  3. [SOLVED] Formula for calculating a new date based on an existing date and other cell criteria
    By scsuflyboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 09:49 AM
  4. sum multiple criteria within two differnt sets of date ranges
    By joedivi1 in forum Excel General
    Replies: 2
    Last Post: 08-22-2012, 01:23 PM
  5. for SUMIF function, how do I use 2 sets of range & criteria
    By Bob in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-10-2006, 03:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1