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...
|