Date adding

[Airbornesolutions]

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

 

[xld]

Try

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

 

[Airbornesolutions]

That's great .... spot on. Thank you very much