Thread: fiscal quarter conversion
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ted McCastlain Ted McCastlain is offline
external usenet poster
  
Posts: 11
Default 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...



Reply With QuoteReply With Quote