Thread: Excel formula to increment the month by 2?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
mphell0
 
Posts: n/a
Default Excel formula to increment the month by 2?

=DATE(YEAR(A3),MONTH(A3)+2,DAY(A3))

where A3 contains the date that you want to add 2 months


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=510939

Reply With QuoteReply With Quote