Hi,
I need a simple formula to get the quarter number from date. In below table, if column A is already date, it should mention the quarter in column B. But if column A is already quarter, it should simply equal in column B. Changing date format is not an option. I tried to create a formula with IF+MONTH+SWITCH etc. but it becomes too complex to understand for other users.
<colgroup><col><col></colgroup><tbody>
</tbody>
I need a simple formula to get the quarter number from date. In below table, if column A is already date, it should mention the quarter in column B. But if column A is already quarter, it should simply equal in column B. Changing date format is not an option. I tried to create a formula with IF+MONTH+SWITCH etc. but it becomes too complex to understand for other users.
A | B |
01.01.2018 | Q1 |
05.02.2018 | Q1 |
10.03.2019 | Q1 |
03.04.2019 | Q2 |
31.05.2018 | Q2 |
Q2 | Q2 |
Q2 | Q2 |
Q3 | Q3 |
Q3 | Q3 |
Q4 | Q4 |
Q4 | Q4 |
<colgroup><col><col></colgroup><tbody>
</tbody>