# Date and Time Functions

## Content

DsExcel.NET provides the following date and time functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [DATE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/date) | This function returns the DateTime object for a particular date, specified by the year, month, and day. |
| [DATEDIF](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/datedif) | This function returns the number of days, months, or years between two dates. |
| [DATEVALUE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/datevalue) | This function returns a DateTime object of the specified date. |
| [DAY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/day) | This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date. |
| [DAYS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/days) | This function returns the number of days between two dates. |
| [DAYS360](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/days360) | This function returns the number of days between two dates based on a 360-day year. |
| [EDATE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/edate) | This function calculates the date which is the indicated number of months before or after a specified date. |
| [EOMONTH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/hour) | This function returns the hour that corresponds to a specified time. |
| [ISOWEEKNUM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/isoweeknum) | This function returns the number of the ISO week number of the year for a given date. |
| [MINUTE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/minute) | This function returns the minute corresponding to a specified time. |
| [MONTH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/month) | This function returns the month corresponding to the specified date value. |
| [NETWORKDAYS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/networkdays) | This function returns the total number of complete working days between the start and end dates. |
| [NETWORKDAYS.INTL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/networkdaysintl) | This function returns the number of workdays between two dates using arguments to indicate holidays and weekend days. |
| [NOW](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/now) | This function returns the current date and time. |
| [SECOND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/second) | This function returns the seconds (0 to 59) value for a specified time. |
| [TIME](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/time) | This function returns the TimeSpan object for a specified time. |
| [TIMEVALUE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/timevalue) | This function returns the TimeSpan object of the time represented by a text string. |
| [TODAY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/today) | This function returns the date and time of the current date. |
| [WEEKDAY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/weekday) | This function returns the number corresponding to the day of the week for a specified date. |
| [WEEKNUM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/weeknum) | This function returns a number that indicates the week of the year numerically. |
| [WORKDAY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/workday) | This function returns the number of working days before or after the starting date. |
| [WORKDAY.INTL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/workdayintl) | 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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/year) | This function returns the year as an integer for a specified date. |
| [YEARFRAC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/date-and-time-functions/yearfrac) | This function returns the fraction of the year represented by the number of whole days between the start and end dates. |