I thought I could do this with Vlookup, but not so sure.

If I know the pay date and the shift, is it possible to have a formula figure what dates that shift will work during that paydate?

Example: if I enter the pay date of 1/28/11 and also what shift I am looking for (we have 3-4 shifts what rotate), will

vlookup work to find the individual dates of the pay period? The pay period always starts on a Saturday at midnight and ends on a Saturday at midnight. So the beginning of our pay can be the 7 hours (midnight to 7) or if the last day lands on a Saturday, it would be 17 hours (0700-midnight).

So in this example if I choose the B shift, it would return the dates of 1-8-11 (last 7), 1-10-11, 1-12-11, 1-14-11 and 1-21-11.

I built the beginning of the list what I would try to use to figure this out.

I am thinking I will need something different than a vlookup, because it is based off of the pay date, pay periods and shift.

any help in the right direction is appreciated.

Thanks.

EXPERT-FIND-DATE-BOOK.xlsx
All you need to do is Click on the command button.

Sid

Code Used - File AOpen in new window

Code Used - File BOpen in new window

File-A.xlsmFile-B.xlsm