+ Reply to Thread
Results 1 to 4 of 4

Pull Data from Date Range

  1. #1
    Registered User
    Join Date
    06-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    96

    Pull Data from Date Range

    Hello,

    I'm looking to create a formula that looks up the pay period based on an inputted date.

    The trick is that I have 1 table with two different pay cycles on it, so I would want for it to control for which Pay Cycle is being addressed, then look up the date from the relevant pay cycle, and return the pay period number for that date.

    In my example, we're looking at Cycle A as indicated by cell B1. The date I'm typing in is cell B2. I would want cell B3 to be a lookup based on the first two rows and the table of dates and pay cycles in columns E-G.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Pull Data from Date Range

    You can try the following formula in B3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    But for 31.10.2019 and Cycle A it will be #N/A because there's no 31.10.2019 at all in column E.
    To show your appreciation
    Click ★ Add reputation!

  3. #3
    Registered User
    Join Date
    06-29-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    96

    Re: Pull Data from Date Range

    Thank you. So I think that is part of my challenge. The dates need to be rounded up to the closest date in the look up range.

  4. #4
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Pull Data from Date Range

    I didn't read your request properly the first time, sorry. You wanted it for a "date range" not for a date for which I provided the above formula.

    You can do it also for intervals with 2 formulas taken from here: https://superuser.com/questions/1333...g-a-date-range

    and adapted for your data (make sure you enter this with CTRL+SHIFT+ENTER as it is an array formula)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I made it for a 3 day difference before and after, but you can change that according to your needs.

    If this solves your request, please mark the thread as solved. Thank you.
    Last edited by Mrrrr; 12-05-2019 at 12:08 PM.

+ 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. How to Pull and Sum Data From Another Spreadsheet Based on a Date Range
    By georgegreenhal3 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-25-2018, 04:24 PM
  2. Pull data from one worksheet to another if date is within range.
    By andrew8473 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-01-2016, 11:32 AM
  3. [SOLVED] Macro to pull data for a specific date range
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2015, 12:17 PM
  4. Pull data from web within date range or recent date
    By Tlandress in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 02-28-2013, 01:44 PM
  5. Pull out different data depending on date range
    By rnomis in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-18-2012, 01:53 PM
  6. expanding date range to pull corresponding data
    By jbschott in forum Excel General
    Replies: 2
    Last Post: 03-28-2010, 10:14 PM
  7. Pull Data for Specified Date Range
    By add1023 in forum Excel General
    Replies: 0
    Last Post: 03-31-2005, 10:32 AM

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