HI all,
need a help on nested if formula for calculating the quarter based on start date and end date
follow is the table
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>column A is the date for which I need quarter in column B.
Example 03-10-2017 comes between 16-09-2017(start date) and 15-12-2017(end date) then my result in column B should be Q3.
Thanks
Chandresh
need a help on nested if formula for calculating the quarter based on start date and end date
follow is the table
Date | Result | Start | End | Output |
03-10-2017 | 01-04-2017 | 15-06-2017 | Q1 | |
16-06-2017 | 15-09-2017 | Q2 | ||
16-09-2017 | 15-12-2017 | Q3 | ||
16-12-2017 | 15-03-2018 | Q4 | ||
16-03-2018 | 31-03-2018 | Q5 |
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Example 03-10-2017 comes between 16-09-2017(start date) and 15-12-2017(end date) then my result in column B should be Q3.
Thanks
Chandresh