Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cubbybear3 cubbybear3 is offline
external usenet poster
  
Posts: 40
Default formula
Try this (I think it will work):

=IF(MONTH(B1)<=3,"Q1",IF(AND(MONTH(B1)=4,MONTH(B1 )<=6),"Q2",IF(MONTH(B1)=10,"Q4","Q3")))

-pb

Reply With QuoteReply With Quote