+ Reply to Thread
Results 1 to 8 of 8

Formula to retrieve dates record based on key date

  1. #1
    Forum Contributor
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    Office 365 and 2021
    Posts
    122

    Formula to retrieve dates record based on key date

    I am trying to populate 3 cells (U, V, W) of date records into column K, L and M. if last day >= payroll start date and <= payroll end date.

    Need some help with the formula to easily add values in columns U, V and W into K, L and M as per condition described above.

    Spreadsheet is attached, I have added some values manually as sample how I wanted them to populate.

    Thanks a lot in advance for your help.

    Rae
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to retrieve dates record based on key date

    Are you saying you're lookong for formulae in columns K:M?

    Why are there blank cells in K:M and what's the rule for ignoring those cells?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    Office 365 and 2021
    Posts
    122

    Re: Formula to retrieve dates record based on key date

    Sorry if wasn't clear. In short, I want to fill values from U, V, and W to K, L, M.

    There are blank cells because I only added date values in K:M to show what I need to achieve.

    For example: In row 2, last day worked date is 2019-12-31, so Excel should populate the dates in column K, L, M from the data available in U, V, W. So if last day was 2018-12-31, it falls within payroll period range of 2018-12-23 to 2019-01-05. I only fill some values into some random rows as an examples to understand the criteria.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Formula to retrieve dates record based on key date

    Please try in K2:M13
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  5. #5
    Forum Contributor
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    Office 365 and 2021
    Posts
    122

    Re: Formula to retrieve dates record based on key date

    Thanks very much Dave. So that works for column K bringing the value in from column U. But the value I need in column L is from column V, and similarly, column M should populate the value from column W. Do I need to add more parameters/forumlas to make all three dates populate? Just like the examples that I have filled in manually. Formula needs to bring in U:W into K:M.

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Formula to retrieve dates record based on key date

    That formula entered in K2 then filled down and across to M13 does all that.

    Please see the attached where it is done.

  7. #7
    Forum Contributor
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    Office 365 and 2021
    Posts
    122

    Re: Formula to retrieve dates record based on key date

    Thank you, Dave. Much appreciated your quick help.

    Regards,
    Rae

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Formula to retrieve dates record based on key date

    You are welcome. Glad to help.

+ 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. Replies: 1
    Last Post: 02-23-2018, 06:38 PM
  2. Store and Retrieve Time Record with reference of Date
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2015, 06:02 PM
  3. Filling listbox based on record dates
    By humboldtguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2014, 01:22 AM
  4. [SOLVED] Help in writing formula in excel to produce dates based on start date and end date
    By shoot for moon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 01:00 PM
  5. Data retrieve based on date
    By mahershams in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-18-2013, 10:29 AM
  6. [SOLVED] Formula to retrieve range of dates from a worksheet to calculate d
    By accented in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2006, 05:55 PM
  7. [SOLVED] How do I retrieve a date in a column of dates which > my criteria
    By HNOWSKI in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-07-2005, 03:05 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