fiscal month formula

[DonnchadhSokol]

this may be a dumb one.

fiscal year starts in june.

want to return fiscal month number.

convert june from 6 to 1, july from 7 to 2, etc... without an IF in there (possible?).

thanks,

nuk

 

[Ron Coderre]

With
A1: a date

This regular formula returns the Fiscal Month Number of that date

B1: =MONTH(EDATE(A1,7))

Does that help?

 

[DonnchadhSokol]

that's perfect!

thanks for the help ron!

 

[gblum]

I have a similar request, except I need the date to convert into a YYYYMM format. For our company 7/1/2013 = 201401; 6/30/2014 = 201412.

 

[Ron Coderre]

This is a really old thread...I think next time, you should start a new thread (and reference any olds that are pertinent )
Meanwhile:
Does this help?
=TEXT(EDATE(A1,6),"YYYYMM")

 

[gblum]

Hi Ron,

That's elegant in its simplicity and powerful in its effectiveness. It works perfectly. Thanks also for the tip on old posts.

Gary
Excel 2010