# Formula to retrieve dates record based on key date

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

Rae

2. ## 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?

3. ## 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. ## Re: Formula to retrieve dates record based on key date

Formula:
`Please Login or Register  to view this content.`

5. ## 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. ## 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. ## Re: Formula to retrieve dates record based on key date

Thank you, Dave. Much appreciated your quick help.

Regards,
Rae

8. ## Re: Formula to retrieve dates record based on key date

You are welcome. Glad to help.

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

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