dtaddyears

Syntax:

Value DateTime  dtaddyears(DateTime dt1, Integer years)

Description:

Adds to dt1 the number of years equal to years.

Examples:

($a1:$a5) = dtaddyears("Jun 28, 2008", $b)
Before:
AB C
11
23
36
410
525
6
After:
AB C
16/28/2009 12:00:00 AM1
26/28/2011 12:00:00 AM3
36/28/2014 12:00:00 AM6
46/28/2018 12:00:00 AM10
56/28/2033 12:00:00 AM25
6
($a1) = dtaddyears(dtnow(), 2)