fiscal quarter conversion
 

Hello all,

I am needing help converting dates to fiscal quarter. Our fiscal
quarter begins on April.

I basically have a cell where I am inputting dates and in another cell
they are converted to "Q107", "Q207", etc.

Thanks for the help...

fiscal quarter conversion
 

Will this do ..

="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{4,1,2,3}) &"07"

A1 contains DATE (in date format)

"Ted McCastlain" wrote:

Hello all,

I am needing help converting dates to fiscal quarter. Our fiscal
quarter begins on April.

I basically have a cell where I am inputting dates and in another cell
they are converted to "Q107", "Q207", etc.

Thanks for the help...

fiscal quarter conversion
 

I like this format: FY2006-Q1
It makes it much easier to sort by FY-Q (in calendar order) if you need to.

If you want this style:
="FY"&YEAR(A1)+(MONTH(A1)=4)&"-Q"&INT(1+MOD(MONTH(A1)-4,12)/3)

But if you want Q107 style:
="Q"&INT(1+MOD(MONTH(A1)-4,12)/3)&RIGHT(YEAR(A1)+(MONTH(A1)=4),2)

Ted McCastlain wrote:

Hello all,

I am needing help converting dates to fiscal quarter. Our fiscal
quarter begins on April.

I basically have a cell where I am inputting dates and in another cell
they are converted to "Q107", "Q207", etc.

Thanks for the help...

--

Dave Peterson

fiscal quarter conversion
 

Excellent worked perfectly!


Toppers wrote:
Will this do ..

="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{4,1,2,3}) &"07"

A1 contains DATE (in date format)

"Ted McCastlain" wrote:

Hello all,

I am needing help converting dates to fiscal quarter. Our fiscal
quarter begins on April.

I basically have a cell where I am inputting dates and in another cell
they are converted to "Q107", "Q207", etc.

Thanks for the help...