Year Date plus one
Year Date plus one
(OP)
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
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





RE: Year Date plus one
RE: Year Date plus one
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
RE: Year Date plus one
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.
RE: Year Date plus one
RE: Year Date plus one
CC's answer is best.
RE: Year Date plus one
RE: Year Date plus one
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
RE: Year Date plus one
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.