Thread: Formula for Calendar Quarter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Robert is offline
external usenet poster
  
Posts: 113
Default Formula for Calendar Quarter
What is the formula to indicate the quarter for a given date (say in cell A1)
e.g. 25-Apr-06 = 2, 4-Jul-06 = 3, 1-Oct-06 = 4.
Thank you
--
Robert
Reply With QuoteReply With Quote