Date formula

[Guest]

How do you put in a formula for a date to change with corresponding number of
years added to it?

example.

column 1 is # of years
column 2 is date
column 3 is calculated current date (# of years added to date)

 

[Niek Otten]

=date(Year(A2)+A1,Month(A2),Day(A2))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Arvi Laanemets]

Hi

C2=DATE(YEAR(B2)+A2,MONTH(B2),DAY(B2))

To cover cases when date falls on 29 February of leap year, use formula
C2=MIN(DATE(YEAR(B2)+A2,MONTH(B2),DAY(B2)),DATE(YEAR(B2)+A2,MONTH(B2)+1,0))


Arvi Laanemets

 

[Niek Otten]

I mixed op rows and columns. Of course Arvi is right.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Thank you very much! Where do you guys learn this stuff?