On attached document, I have Column C of Date Values. On the next sheet titled "Pay Period" I have a table. This table has dates in column A and B.
On Sheet1 Column J, labed "Pay Period". I would like it to find which pay period Cell C2 falls in and result be the value of Column C of Sheet "Pay Periods". I am trying to use the following formula and it is not working: