+ Reply to Thread
Results 1 to 4 of 4

Check a date range and return value based on the date range

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    2

    Check a date range and return value based on the date range

    hello, I really need help with this.
    I have two sheets- the first one has an option to put in a date range as seen below:

    Start Date End Date
    14/07/2015 22/07/2015

    in the second sheet i have a yearly schedule for all my staff, but the way i have it laid out is the number of staff that will be in the office in the first column and the date will be in the second column, like below:

    staffed Date
    20 13/07/2015
    21 14/07/2015
    22 15/07/2015
    20 16/07/2015
    19 17/07/2015

    What i need the formula to do is check the date range in the first sheet against the numbers and dates in the second one and return a value.

    Example- i put a start and end date of my holidays into it, it checks the sheet and if i have less than 20 staffed on any of the dates specified it will say rejected. put if there is 20 or more staffed each day it will say approved.


    I have added screen shots in the hope that i helps you to understand what i mean
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,442

    Re: Check a date range and return value based on the date range

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    07-13-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    2

    Re: Check a date range and return value based on the date range

    As requested i have added a fake copy of the spread sheet, you will notice that on the dashboard tab person 1 is looking for 14/07/2015 until the 22/07/2015 as holidays and in cell H2 it states approved. so basically when there is 20 or more people staffed for week it will return approved and if not it will return rejected.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,442

    Re: Check a date range and return value based on the date range

    Please mark the related cells with the same color for better understanding.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return value based on date range
    By nehabhaumi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-26-2014, 02:37 PM
  2. [SOLVED] Pricing Check - based on a dynamic date range
    By Deventus in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-08-2014, 10:24 AM
  3. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  4. [SOLVED] Return Value based upon date range
    By tsmor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-06-2013, 11:05 PM
  5. Return 1 or 0 based on Date Range
    By kwjoh in forum Excel General
    Replies: 8
    Last Post: 03-04-2011, 10:55 PM
  6. Excel 2007 : Want to return a value based on date range
    By mlittle74 in forum Excel General
    Replies: 2
    Last Post: 04-03-2010, 01:23 PM
  7. Compare Dates To Date Range & Return Date Based On Outcome
    By gusmontoya in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-03-2008, 09:06 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