Convert Calendar month to Financial Month

[SamS]

I need a formula that looks at todays date and returns the financial month (not calendar)as an integer eg February should be returned as 8 and can be either +ve or -ve as I will use abs() to convert it. I know it can be done with a lookup table but I was hoping to avoid this. Should be easy but maths was not my strong subject.

 

[Guest]

=MONTH(TODAY())

 

[Guest]

Should read :-

=MONTH(TODAY())+6

 

[SamS]

On 2002-03-05 17:08, Anonymous wrote:
Should read :-

=MONTH(TODAY())+6

not quite, the financial periods run from July to June therefore the above formulas for December returns 18 where as it should return 6.

 

[Guest]

=IF(MONTH(B1)>6,MONTH(B1)-6,MONTH(B1)+6)

 

[SamS]

Thanks - modified to fit my requirement of current month as follows:
=IF(MONTH(NOW())>6,ABS(MONTH(NOW())-6),MONTH(NOW())+6)

should have known this ops