aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi All
Can you please help me with below scenario
I have dates in (dd/mm/yyyy format) columnA and I need to write a formula in Column B to group the dates in to quarters.
Example if the date is less than or equal to dec 31 2021 then in column B it should appear as "Pre Dec 2021"
If the date falls between 1 Jan 2022 - 31 Mar 2022 then in column B it should appear as "Q1 2022", if dates falls in between 1 Apr 2022 - 30 June 2022 then it should appear as "Q2 2022"
Thanks
Can you please help me with below scenario
I have dates in (dd/mm/yyyy format) columnA and I need to write a formula in Column B to group the dates in to quarters.
Example if the date is less than or equal to dec 31 2021 then in column B it should appear as "Pre Dec 2021"
If the date falls between 1 Jan 2022 - 31 Mar 2022 then in column B it should appear as "Q1 2022", if dates falls in between 1 Apr 2022 - 30 June 2022 then it should appear as "Q2 2022"
Thanks