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.