OK....That helps immensely.
With
Your posted table on Sheet2,
beginning in cell A1,
with Row_1 containing column headings
Then....On Sheet1
A1: (a date to test)
C1: (the start of a date range)
D1: (the end of the date range)
If the test date is withing the date range,
this formula returns the pay period of the test date:
B1: =IF(AND(A1>=A3,A1<=A4),MATCH(A1,Sheet2!C2:C27,1),"not within date range")
Note: That is assuming the date range is within the payroll year detailed on Sheet2. If that may not be the case, we can put additional tests in the formula.
Does that help?
Bookmarks