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:
A
B
C
1
1
2
3
3
6
4
10
5
25
6
After:
A
B
C
1
6/28/2009 12:00:00 AM
1
2
6/28/2011 12:00:00 AM
3
3
6/28/2014 12:00:00 AM
6
4
6/28/2018 12:00:00 AM
10
5
6/28/2033 12:00:00 AM
25
6
($a1) = dtaddyears(dtnow(), 2)