dtdaydiff

Syntax:

Value Integer  dtdaydiff(DateTime dt1, DateTime dt2)

Description:

Returns the number of days between dt1 and DateTime dt2.

Examples:

($a1:$a5) = dtdaydiff("Jun 28, 2008", $b)
Before:
AB C
1Sep 23, 2003
2Aug 15, 2011
3Dec 25, 2000
4July 4, 1998
5March 30, 2015
6
After:
AB C
11740Sep 23, 2003
2-1143Aug 15, 2011
32742Dec 25, 2000
43647July 4, 1998
5-2466March 30, 2015
6
($a1) = dtdaydiff(dtnow(), "Oct 3, 1987")