Date formula

C

Confused

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)
 
N

Niek Otten

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
A

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
 
N

Niek Otten

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top