Column A is a bunch of dates (MM/DD/YYYY) and Column B is blank. I need an equation for Column B that adds a year to the date in column A of the same row. Any ideas?
2007-03-22 05:59:20 · 7 answers · asked by Hidden 2 in Computers & Internet ➔ Software
To avoid problems with leap years and still always get the same date in the next year, use this formula starting in B1:
=DATE(YEAR(A1+1), MONTH(A1), DAY(A1))
2007-03-22 08:18:51 · answer #1 · answered by nospamcwt 5 · 0⤊ 0⤋
=sum(A1+365) and format column B in date format. Just change A1 to A2, A3, A4 etc to continue the series down or pull the fill handle down to populate column B's entries.
2007-03-22 13:04:52 · answer #2 · answered by John S Wiggins 4 · 0⤊ 0⤋
type=click in column A+365
2007-03-22 13:07:17 · answer #3 · answered by sreekrishnakrupa 2 · 0⤊ 0⤋
Since there is a leap year involved, you will have to put
=A1+366 instead of 365
2007-03-22 13:08:10 · answer #4 · answered by NaturalPhotos 2 · 0⤊ 0⤋
Let's say your dates are starting in row 5. You would type "=A5+YYYY" into cell B5, where YYYY is what you want to add. Then drag it down.
2007-03-22 13:04:14 · answer #5 · answered by William S 3 · 0⤊ 0⤋
use the help for Excel. But if you hit the little f(x) button at the top you can get started there
2007-03-22 13:03:53 · answer #6 · answered by Anonymous · 0⤊ 0⤋
=A1+365
or
=MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2) +1
2007-03-22 13:06:20 · answer #7 · answered by Bb 1 · 0⤊ 0⤋