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
|