How to create a date to show the first date of the previous quarter
Hi, I am trying to find a formula that returns the first day of the previous quarter based on a date column (TODAY).
-if the date column is 02/01/2024, the formula should return 01/10/2023
-if date column is 31/06/2023, the formula should return 01/01/2023
Any help would be much appreciated. Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!