adding date using date() function

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,551
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

01/01/201902/12/2019

<tbody>
</tbody>

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

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,551
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,638
Office Version
365
Platform
Windows
How about
=EDATE(A1,14)+3
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,551
Thank you all. I got it. Very nice to see different styles. Thank you.
 
Last edited:

Forum statistics

Threads
1,085,309
Messages
5,382,877
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top