D

#### duketter

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!