Comparisons of Microsoft Excel functions to those available in Anaplan.

Use the links below to navigate to pages containing other Microsoft Excel functions.

A B C D E F G H I L M N O P Q R S T U V W X Y

Excel functionExcel descriptionAnaplan solution
WEEKDAYReturns 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.
WEEKNUMReturns the week number for a date.There's no equivalent Anaplan function, but can be built using a calculation.
WORKDAYAdds 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.INTLAdds 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.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.