SUMOFFSET help with fiscal/calendar year confusion

[John44]

Hi,

I've built a SUMOFFSET formula to add up the correct number of months depending on what reporting month it is. REPORTINGMONTH being a named cell. However my formula breaks down because the fiscal year starts in May and not Jan. I found an IF statement to help so I need to combine the two somehow but then it doesn't work. Can someone help me please?

John

 

[JamesCanale]

Not sure what you are looking for here, but maybe this:

MrExcelPlayground20.xlsx
	B	C
1	May-23	1
2	Jun-23	2
3	Jul-23	3
4	Aug-23	4
5	Sep-23	5
6	Oct-23	6
7	Nov-23	7
8	Dec-23	8
9	Jan-24	9
10	Feb-24	10
11	Mar-24	11
12	Apr-24	12
Sheet22

Cell Formulas
Range	Formula
C1:C12	C1	=MONTH(EOMONTH(B1,-4))

 

[John44]

Let me incorporate this. I'll revert. thank you.

 

[John44]

Great. Thank you it worked!