How to find last month and year if April is a starting month

[pra_kale]

Hi,

I want to find a last month  if I am considering April as a starting month i.e. 1 and March is 12. I am using following formula but it is not working in month of April. Formula is giving 0 as a output where as output should be 12.

=num(Month(Today())-(Num(Month(Today()))-Mod(month(today())-4, 12)))

Same i want to find a corresponding year i.e. 2015.

Please help to resolve the issue.

Thanks in Advance.

[ecolomer]

See this:

Fiscal Year

Fiscal and Standard Calendar generation

[Gysbert_Wassenaar · Accepted solution]

Try =num(Month(MonthStart(Today(),-4))) and =Year(MonthStart(Today(),-4))

[pra_kale]

It is working...

Thank you very much Gysbert...