I’m trying to use a formula column to return the fiscal quarter and year (ours starts in April) , EG: Q1-24, from a date. We will have some blanks in the date column which I’d like to return a blank in the formula column.
For example April 5th 2023 would be Q1-24 and Jan 5th 2024 would be Q4-24.
I’ve found similar answers and tried some of the suggested formulae, but unfortunately run out of intelligence when I try and adapt them to our use case.
I’d be very grateful if someone could help us with this please?
We just to be sure we are understanding your goal correctly, to confirm, you’d like to output a fiscal year (in the format or Q1-24) based upon a specific date set in the date column - correct? Is it possible to send a screenshot of your current set up? Or alternatively, formulae you have tried to use to achieve this, so we can be sure we take the right approach?