Forum Discussion
Adding years to a date
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.
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.
