Use Excel's date and time functions in your Anaplan XL reports.
| Function | Description |
| DATE | Returns the serial number that represents a date. |
| DATEDIF | Returns the difference of two dates in years, months, or days. |
| DATEVALUE | Converts date text to a DATEVALUE serial number. |
| DAY | Returns the corresponding day of the month serial number or date text from 1 to 31. |
| DAYS | Returns the number of days between the two specified dates. |
| DAYS360 | Returns the number of days between two set dates based on a 360-day year. |
| EDATE | Returns the value or serial number of the date, which is a certain number of months before or after a user-specified date. |
| EOMONTH | Returns the date at the end of the month a specified number of months before or after a specified date. |
| HOUR | Returns the hour as a serial number integer between 0 and 23. |
| ISOWEEKNUM | Returns the ISO week number for a specified date. |
| MINUTE | Returns the serial number that corresponds to the minute. |
| MONTH | Returns the corresponding serial number of the month of a date between 1 and 12. |
| NETWORKDAYS | Returns the number of working days between two dates. Excludes weekends and specified holidays. |
| NETWORKDAYS.INTL | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. |
| NOW | Returns the current date and time in the form of a serial number. |
| SECOND | Returns the seconds portion of a serial time value. |
| TIME | Returns the decimal value of a given time. |
| TIMEVALUE | Returns the decimal number for a given time. |
| TODAY | Returns the current date as a serial number. |
| WEEKDAY | Returns the corresponding day of the week as a serial number. |
| WEEKNUM | Returns the number where a week falls numerically within a year. |
| WORKDAY | Returns a date that is a specified number of working days before or after a given date. |
| WORKDAY.INTL | Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days. |
| YEAR | Returns the corresponding year as a serial number in the form of an integer. |
| YEARFRAC | Calculates the fraction of the year between two dates. |
