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


This may depend on what result you want. If your original date (in cell
A1) is
31st December 2005 then

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

will give you a result of 3rd March 2006

whereas

=EDATE(A1,2)

will give you

28th February 2006

note EDATE is part of Analysis ToolPak add-in


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