Date functions

NAME	DESCRIPTION
DATEADD	Adds a specified number of days to the input date
DATEDIFF	Returns the number of days between two input dates
DAY	Extracts the day of the month from an input date
DATE	Returns a date in the specified format
DATE.SET	Returns a date after changing the format
DATE.FORMAT	Returns the current date in the specified format
SOWEEK	Returns the starting date of the week
SOMONTH	Returns the starting date of the month
SOQTR	Returns the starting date of the quarter
SOYEAR	Returns the starting date of the year
EOWEEK	Returns the last date of the week
EOMONTH	Returns the last date of the month
EOQTR	Returns the last date of the quarter
EOYEAR	Returns the last date of the year
NETWORKDAYS	Returns the number of workdays between two input dates
ADDDAYS	Adds a specified number of days to the input date
ADDWEEKS	Adds a specified number of weeks to the input date
ADDMONTHS	Adds a specified number of months to the input date
ADDQTRS	Adds a specified number of quarters to the input date
ADDYEARS	Adds a specified number of years to the input date
FROMEXCELDATE	Converts an input date to a excel format date serial number
MONTH	Extracts the month from an input date
NOW	Returns the current date and timestamp
TODAY	Returns the current date
TOEXCELDATE	Converts an excel recognized serial number to the equivalent date
YEAR	Extracts the year from an input date