ExcelBanter - add to date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - add to date (https://www.excelbanter.com/excel-discussion-misc-queries/244399-add-date.html)

NAS

add to date

I need help on how to get a code or function to add 3 years to dates in an
excel doc. For example take todays date and add 3 years to get 10/02/2012
automatically.

Gary''s Student

add to date

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

Just be careful of Leap Years.
--
Gary''s Student - gsnu200906

"NAS" wrote:

I need help on how to get a code or function to add 3 years to dates in an
excel doc. For example take todays date and add 3 years to get 10/02/2012
automatically.

All times are GMT +1. The time now is 03:04 AM.