Airbornesolutions
New Member
- Joined
- Sep 17, 2008
- Messages
- 18
Hello
I would like to know the frmula so I can enter a date in cell "A" and have cell "B" display the date (dd/mm/yyyy) exactly one year from the original date. I tried =cellA+365 however in some cases this returned a date not exactly one year ahead ..... I guess due to leap years?
Any ideas
Thank you
I would like to know the frmula so I can enter a date in cell "A" and have cell "B" display the date (dd/mm/yyyy) exactly one year from the original date. I tried =cellA+365 however in some cases this returned a date not exactly one year ahead ..... I guess due to leap years?
Any ideas
Thank you