adding date using date() function

[lezawang]

Hi
I have in cell A1=1/1/2019 and I want to add 1 year to that date. So I did this B1 = A1+date(1,0,0) but I got wrong answer

[TABLE="class: grid, width: 150"]
<tbody>[TR]
[TD="width: 75, align: right"]01/01/2019[/TD]
[TD="width: 75, align: right"]02/12/2019[/TD]
[/TR]
</tbody>[/TABLE]

Any idea why? I thought I should get 1/1/2020. Thank you very much.

 

[James006]

Hi,

You could test

= Edate(A1,12)

Hope this will help

 

[lezawang]

Thank you that helps in that example but lets say if I want to add 1 year, 2 month, 3 days to a date. Can it be done using one function? Thank you once again

 

[Fluff]

How about
=EDATE(A1,14)+3

 

[Jonmo1]

lets say if I want to add 1 year, 2 month, 3 days to a date.

Try

=DATE(YEAR(A1)+1,MONTH(A1)+2,DAY(A1)+3)

 

[lezawang]

Thank you all. I got it. Very nice to see different styles. Thank you.

 

[James006]

For sure ... problem is solved ...