Hi all,
I need to be able to check if a cell falls in between of 2 dates in a list. I don't need to calculate the difference between times or only return a True or False, but instead find what shift the particular time in the cell corresponds with.
Attached is a sample sheet of what I'm looking for. I need to be able to take the TRANSDATE and return what SHIFT it falls in which DEPT.
The reason I don't want to hard code this into the formula is because the shifts change frequently depending on our customer demand, overtime, etc. I'm thinking it may have to be an INDEX and MATCH, but I'm not sure how to set them up.
Any help appreciated.
I need to be able to check if a cell falls in between of 2 dates in a list. I don't need to calculate the difference between times or only return a True or False, but instead find what shift the particular time in the cell corresponds with.
Attached is a sample sheet of what I'm looking for. I need to be able to take the TRANSDATE and return what SHIFT it falls in which DEPT.
The reason I don't want to hard code this into the formula is because the shifts change frequently depending on our customer demand, overtime, etc. I'm thinking it may have to be an INDEX and MATCH, but I'm not sure how to set them up.
Any help appreciated.