# Date and Time Functions

## Content

Spread provides the following date and time functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [DATE](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/DATE) | This function returns the DateTime object for a particular date, specified by the year, month, and day. |
| [DATEDIF](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/DATEDIF) | This function returns the number of days, months, or years between two dates. |
| [DATEPART](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/datepart-function) | This function returns the Date object for a particular date, specified by the year, month, and day. |
| [DATEVALUE](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/DATEVALUE) | This function returns a DateTime object of the specified date. |
| [DAY](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/DAY) | This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date. |
| [DAYS](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/DAYS) | This function returns the number of days between two dates. |
| [DAYS360](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/DAYS360) | This function returns the number of days between two dates based on a 360-day year. |
| [EDATE](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/EDATE) | This function calculates the date which is the indicated number of months before or after a specified date. |
| [EOMONTH](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/EOMONTH) | This function calculates the date for the last day of the month (end of the month) which is the indicated number of months before or after the starting date. |
| [HOUR](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/HOUR) | This function returns the hour that corresponds to a specified time. |
| [ISOWEEKNUM](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/ISOWEEKNUM) | This function returns the number of the ISO week number of the year for a given date. |
| [MINUTE](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/MINUTE) | This function returns the minute corresponding to a specified time. |
| [MONTH](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/MONTH) | This function returns the month corresponding to the specified date value. |
| [NETWORKDAYS](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/NETWORKDAYS) | This function returns the total number of complete working days between the start and end dates. |
| [NETWORKDAYS.INTL](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/NETWORKDAYS.INTL) | This function returns the number of workdays between two dates using arguments to indicate holidays and weekend days. |
| [NOW](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/NOW) | This function returns the current date and time. |
| [SECOND](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/SECOND) | This function returns the seconds (0 to 59) value for a specified time. |
| [TIME](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/TIME) | This function returns the TimeSpan object for a specified time. |
| [TIMEVALUE](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/TIMEVALUE) | This function returns the TimeSpan object of the time represented by a text string. |
| [TODAY](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/TODAY) | This function returns the date and time of the current date. |
| [WEEKDAY](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/WEEKDAY) | This function returns the number corresponding to the day of the week for a specified date. |
| [WEEKNUM](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/WEEKNUM) | This function returns a number that indicates the week of the year numerically. |
| [WORKDAY](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/WORKDAY) | This function returns the number of working days before or after the starting date. |
| [WORKDAY.INTL](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/WORKDAY.INTL) | This function returns the serial number of the date before or after several workdays with custom weekend parameters. These parameters indicate weekend days and holidays. |
| [YEAR](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/YEAR) | This function returns the year as an integer for a specified date. |
| [YEARFRAC](/spreadjs/docs/v17/formulareference/FormulaFunctions/date-time-functions/YEARFRAC) | This function returns the fraction of the year represented by the number of whole days between the start and end dates. |