+ Reply to Thread
Results 1 to 8 of 8

Formula to retrieve dates record based on key date

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    2016
    Posts
    83

    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 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
    26,827

    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

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

  3. #3
    Registered User
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    2016
    Posts
    83

    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
    2007, Office 365
    Posts
    11,597

    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
    Registered User
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    2016
    Posts
    83

    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
    2007, Office 365
    Posts
    11,597

    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
    Registered User
    Join Date
    04-30-2012
    Location
    US
    MS-Off Ver
    2016
    Posts
    83

    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
    2007, Office 365
    Posts
    11,597

    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. 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. 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