On Wed, 13 May 2009 11:26:02 -0700, duketter
wrote:

Excel 2007 - I have a specific date in cell A1 for example. A1 - 3/31/2009.
I then want in cell G1 the exact next year calculated so for example cell G1
would show 3/31/2010. Then in cell H1 it would show 3/31/2011, I1 it would
show 3/31/2012.

The date in cell A1 changes so that is why I need the formula for this. I
have tried just putting the following formula in cell G1: =A1+365. However,
when I hit leap year it screws up the days and goes to 3/30/2012, 3/29/2016
etc.

How can I get this to calculate exactly the next year and input the data?

Thanks!

=MIN(DATE(YEAR(A1)+1,MONTH(A1)+{0,1},DAY(A1)*{1,0} ))

--ron