Inserting Quarter and Year for fiscal year (July-June)
Tried to use other formulas on here, but can't seem to get it to work. Our fiscal year is June - July. Trying to have a column show Q1 - FY22 if a date referenced is July - Sept 2021, Q2 - FY22 if a date referenced is Oct - Dec 2021, etc. The column I want to read against is "Completed Date" and both columns (Completed Date and Qtr Yr Complete) are formatted for date.
Any help is appreciated.
Help Article Resources
Check out the Formula Handbook template!