Thread: IF and DATE Formula Help PLEASE
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darren Bartrup[_2_] Darren Bartrup[_2_] is offline
external usenet poster
  
Posts: 36
Default IF and DATE Formula Help PLEASE
Should work:

=IF(B2<"",DATE(YEAR(B2)+2,MONTH(B2),DAY(B2)),DATE (YEAR(A2),MONTH(A2)+6,DAY(A2)))
Reply With QuoteReply With Quote