I have a table below for period.
Sheet 1
<tbody>
</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 3/15/18 fall in period 2 and so on.
Please help. Looking for a solution as soon as possible.
thank you in advance
Sheet 1
Start Date | End Date | Period |
2/4/2018 | 3/3/2018 | Period 1 |
3/4/2018 | 3/31/2018 | Period 2 |
<tbody>
</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 3/15/18 fall in period 2 and so on.
Please help. Looking for a solution as soon as possible.
thank you in advance