View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Calculate a Date

On Mon, 8 Sep 2008 19:22:00 -0700, Teethless mama
wrote:

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


I think you overlooked this part of the request:

... taken to the 1st of the following month **IF** that date does not occur on the 1st of the month.


In interpret that to mean that

7/1/2008 -- 7/1/2010
7/2/2008 -- 8/1/2010

--ron