dtmonthnum

Syntax:

Value String  dtmonthnum(DateTime dt1)

Description:

Returns the month number of dt1 (1...12).

Examples:

($a1:$a5) = dtmonthnum($b)
Before:
AB C
1Sep 23, 2003 4:49:44 AM
2Aug 15, 2011 12:43:32 PM
3Dec 25, 2000 9:27:55 PM
4Jul 4, 1998 3:16:18 AM
5Mar 30, 2015 8:03:44 PM
6
After:
AB C
19Sep 23, 2003 4:49:44 AM
28Aug 15, 2011 12:43:32 PM
312Dec 25, 2000 9:27:55 PM
47Jul 4, 1998 3:16:18 AM
53Mar 30, 2015 8:03:44 PM
6
($a1) = dtmonthnum(dtnow())