Calculate Future Date for Column

[prosportal]

I tried searching this, but I wasn't having much luck.

Column A1 through A50 are dates mm/dd/yyyy

I need Column B1 through B50 to be the A column date + 1 year.

Currently, I'm using =A1 + 365, but I'm having to do that for each row.

Is there a function that will show a year from Column A for each corresponding B row?

[JieJenn]

In B1, enter =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)) and fill the formula.

[Jonmo1]

You could use

=EDATE(A1,12)

[JohnTopley]

Removed by JT

[JieJenn]

You could use

=EDATE(A1,12)

EDATE function is yet available in Excel 2003 if that's what he/she is currently using.

[Jonmo1]

Good point, but Yes it is available. It's just not installed by default.
You'd have to go to Tools - Addins and check "Analysis Toolpack"

[prosportal]

EDATE actually works, but how do I calculate each row automatically?
AjCNb8Z.png

[Jonmo1]

You just have to 'Fill' it down.

Click on the first cell you put the formula in.
You should see a tiny little square at the bottom right of that cell, double click it.

[prosportal]

That did it! Thanks Jonmo1.

[Jonmo1]

You're welcome.