I have a table below for period.
Sheet 1
<tbody>
Start Date
End Date
Period
2/4/2018
3/3/2018
Period 1
3/4/2018
3/31/2018
Period 2
</tbody>
Sheet 2
Has Hire date column C2 (2/15/18).
I am looking for help to whether I can use if formula to say 2/15/18 fall in Period 1, whereas if is...