Excel formula query

[Grahamfff]

I have a column of dates in the form 11/12/2024 and need a formula which will return 2024-25 (Quarter 3). (My. financial year is April - March)

 

I've experimented and Googled but not cracked it - can anyone help? 

 

Thanks!

[alchresearch]

Is this any help?

 

https://exceljet.net/formulas/get-quarter-from-date

[alchresearch]

Can't edit but I've just tried it on a worksheet of mine with dates going all through the year and its worked fine.

[Grahamfff]

Thanks for this!

 

The formula at the beginning of the linked page doesn't work for me, because it assumes January is the beginning of quarter 1.

 

So, reading own that page I've not got so fas as this: if the date 01/04/2024  is in cell A2, then this formula

 

=YEAR(A2)&" - "&"Q"&CHOOSE(MONTH(A2),4,4,4,1,1,1,2,2,2,3,3,3)

 

will return 2024 - Q1

 

This is definitely progress, but the problem is that the formula will always return the calendar year, whereas ideally, the year will be expressed as 2024 - 2025 for all dates from 1/1/2024 to 31/3/2024. Or at least, for those dates, the year will be 2025.

 

This is important because ultimately, I want to use this column as a slicer in a pivot table.

 

Happy to receive any more suggestions!

 

 

[Grahamfff]

I think I'v resolved this now.

Thanks for your help.