SOLVED

Adding years to a date

Copper Contributor

I am trying to add years to a date.

 

I've tried 2 formulas but I get a #Value! error.

 

The first formula is =EDATE(I4,(X4/12))

The second formula is =DATE(YEAR(I4)+w4,month(I3),DAY(I4))

 

For both formulas the original date is I4.

The number of years is W4.

The number of months is X4.

 

I don't know what I'm doing wrong. I would be very grateful for any help.

3 Replies
What value is in I3?
best response confirmed by Chuck950 (Copper Contributor)
Solution

@Chuck950  So I see a couple things:

The first formula is =EDATE(I4,(X4/12))   --->  EDATE moves by months so try: =EDATE(I4,X4)

The second formula is =DATE(YEAR(I4)+w4,month(I3),DAY(I4))   --->  What is I3?  typo?

On another note please make sure I4 is actually a DATE VALUE and not a text value that just looks like a date.  Simple test: =I4+1  should produce a result of the next day.  If it errors then I4 is most likely text that looks like a date to YOU but not to Excel.

@mtarler

 

Thank you so much for your help. My vision is poor and I missed the typo. Thank you for catching it. 

1 best response

Accepted Solutions
best response confirmed by Chuck950 (Copper Contributor)
Solution

@Chuck950  So I see a couple things:

The first formula is =EDATE(I4,(X4/12))   --->  EDATE moves by months so try: =EDATE(I4,X4)

The second formula is =DATE(YEAR(I4)+w4,month(I3),DAY(I4))   --->  What is I3?  typo?

On another note please make sure I4 is actually a DATE VALUE and not a text value that just looks like a date.  Simple test: =I4+1  should produce a result of the next day.  If it errors then I4 is most likely text that looks like a date to YOU but not to Excel.

View solution in original post