Comparisons of Microsoft Excel functions to those available in Anaplan.
Excel function | Excel description | Anaplan solution |
WEEKDAY | Returns a number representing the day of the week, given a date value. | Use the WEEKDAY formula to take a date and return a number from 1 to 7 for the day of the week. An optional Type parameter can be used to set the start day for the day of the week count. |
WEEKNUM | Returns the week number for a date. | There's no equivalent Anaplan function, but can be built using a calculation. |
WORKDAY | Adds a specified number of work days to a date, and returns the result as a serial date. | There's no equivalent Anaplan function, but can be built using a calculation. |
WORKDAY.INTL | Adds a specified number of work days to a date, and returns the result as a serial date (customizable weekends). | There's no equivalent Anaplan function, but can be built using a calculation. |