View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
kza40381 kza40381 is offline
external usenet poster
 
Posts: 4
Default How do I convert a specific date to a fiscal quarter ?

Hi Dave...i apologize if this is a novice question, but can you provide a
formula which shows qtrs as Jan-March, Apr-June-July-Sept, October-December?
Thank you so much!

"Dave Peterson" wrote:

Thanks for the correction.

JE McGimpsey wrote:

In article ,
Dave Peterson wrote:

July 1, 2007 is quarter 1 of 2007???


Actually, the OP implied that July 1, 2007 would be quarter 1 of FY2008.

July 1 is a very common start date for fiscal years.


--

Dave Peterson