Hi Everyone,
I need some help . I have an outcome due date column in excel but i need to update in excel the due date falls under which quarter of the year.
For example the due date is on 27th April 2021 and this falls under Quarter 2 of the year. I tried using loop and calc stage to achieve this but i could not find the right way to do this. Can someone help me
1/1/2021 till 31/3/2021 : Quarter 1
1/4/2021 till 30/6/2021 : Quarter 2
1/7/2021 till 30/9/2021 : Quarter3
1/10/2021 till 31/12/2021 : Quarter 4
I need some help . I have an outcome due date column in excel but i need to update in excel the due date falls under which quarter of the year.
For example the due date is on 27th April 2021 and this falls under Quarter 2 of the year. I tried using loop and calc stage to achieve this but i could not find the right way to do this. Can someone help me
1/1/2021 till 31/3/2021 : Quarter 1
1/4/2021 till 30/6/2021 : Quarter 2
1/7/2021 till 30/9/2021 : Quarter3
1/10/2021 till 31/12/2021 : Quarter 4