> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/~/changes/mS6jwvARNLHpKqBa4cT9/formula-syntax/date-functions.md). # 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

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.inforiver.com/~/changes/mS6jwvARNLHpKqBa4cT9/formula-syntax/date-functions.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.