DAYS: Obtaining the Number of Days Since January 1, 1900

Syntax: How to Obtain the Number of Days Since January 1, 1900

DAYS(arg)

where:

arg

Date or timestamp

Is the input argument.

This function returns an integer value.

DAYS returns the number of days since January 1, 1900. This example,

DAYS('2000-01-01')

returns 36525.