lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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
<tbody>
</tbody>
Any idea why? I thought I should get 1/1/2020. Thank you very much.
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/2019 | 02/12/2019 |
<tbody>
</tbody>
Any idea why? I thought I should get 1/1/2020. Thank you very much.