Thread: calculate difference between 2 dates
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default calculate difference between 2 dates
=CHOOSE(1+(B1<DATE(YEAR(A1),MONTH(A1)-MOD(MONTH(A1)-1,3),1))
+2*(B1DATE(YEAR(A1),3+MONTH(A1)-MOD(MONTH(A1)-1,3),0)),"Within the
quarter","Pull in","Push out of quarter")

Regards,
Bernd
Reply With QuoteReply With Quote