Year Date plus one 1

[diamondjim]

I want to copy all of the dates in a column in excell
but add 1 year to the dates and have it appear in the next column. I tried =H1 + 1 and several other ideas but
the day changes by one.
Thanks

 

[VEBill]

Try "+ 365".

 

[CajunCenturion]

You could try the following formula
New date is J1

=DATE(YEAR(H1)+1, MONTH(H1), DAY(H1))

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[analogkid2digitalman]

Unless it is a yeap lear

Wheels within wheels / In a spiral array
A pattern so grand / And complex
Time after time / We lose sight of the way
Our causes can't see / Their effects.

 

[VEBill]

Oh, you'll have to watch out for leap years as they'd be a day off in that case.

 

[VEBill]

Four replies inside two minutes... I'm glad they've added the time to the posting date.

CC's answer is best.

 

[MintJulep]

Make a custom function using VBA and use the VB "Dateadd" function.

 

[IRstuff]

Excel's internal date serial number format is based on the number of days since 1/1/1900 or somesuch thing. The fraction is the elapsed portion of the day since midnight.

That's why adding 365 will mostly work. A more complicated scheme would involve decomposing the actual year, month, day, adding 1 to the year and reconstructing the date serial number. That's assuming your goal is to get the same date, only 1 yr later.

TTFN

 

[diamondjim]

=DATE(YEAR(H1)+1, MONTH(H1), DAY(H1))
That worked perfectly. Thanks!

Thanks for your other ideas as well
+ 365 and + 366 for the leap year
would work but caution would be required
or an if statement included.