fiscal month formula

DonnchadhSokol

New Member
Joined
Jun 9, 2011
Messages
4
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Ron Coderre

MrExcel MVP
Joined
Jan 14, 2009
Messages
2,316
With
A1: a date

This regular formula returns the Fiscal Month Number of that date
Code:
B1: =MONTH(EDATE(A1,7))
Does that help?
 

gblum

New Member
Joined
Sep 26, 2006
Messages
2
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

MrExcel MVP
Joined
Jan 14, 2009
Messages
2,316
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

New Member
Joined
Sep 26, 2006
Messages
2
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,044
Messages
5,466,209
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top