Thread: Computing full Months
View Single Post
  #2   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default
=IF(DAY(A1)=1,DATE(YEAR(A1),MONTH(A1)+3,1),DATE(YE AR(A1),MONTH(A1)+4,1))

HTH,
Bernd


Reply With QuoteReply With Quote