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
|