DATE2NUMBER

Converts a date into date serial.

Syntax

DATE2NUMBER(date_input)

date_input - the date to be considered.

Example

DATE2NUMBER(“1/1/2012”) equals 40179