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
DATEReturns the serial date value for a date.Use the DATE function to convert numbers yyyy, mm, and dd into a date. The date format depends on your locale.
DATEDIFReturns the difference between two date values, based on the interval specified.Use the DECUMULATE function to calculate the difference in a value in the current period vs previous period.
DATEVALUEReturns the serial number of a date.Use Date Settings.
DAVERAGEAverages all numbers in a column in a list or database, based on specified criteria.Use the x[AVERAGE]:y aggregation function.
DAYReturns the day of the month (a number from 1 to 31) given a date value.Use the DAYS function to convert a date into a day in number format. The date format depends on your locale.
DAYSReturns the number of days between two dates.Use the DAYS function to return the number of days in a time period. You can use a single time period parameter or no parameter to return the number of days in a time period.
DAYS360Returns the number of days between two dates based on a 360-day year.Use the DAYS function to return the number of days in a time period. You can use a single time period parameter or no parameter to return the number of days in a time period.
DBReturns the depreciation of an asset based on the fixed-declining balance method.See the Financial Functions.
DCOUNTReturns the number of cells in a column or database that contains numeric values and meets the given criteria.Use the SUM function.
DCOUNTAReturns the number of cells in a column or database that contains nonblank values and meets the given criteria.Use the SUM function.
DDBReturns the depreciation of an asset based on the double-declining balance method.See Financial Functions.
DEGREESConverts radians to degrees.There is no equivalent Anaplan function, but can be built using a calculation.
DGETRetrieves from a database a single record that matches the given criteria.Use the ITEM function.
DMAXReturns the largest number in a column in a list or database, based on the specified criteria.Use the MAX function.
DMINReturns the smallest number in a column in a list or database, based on the specified criteria.Use the MIN function.
DOLLARConverts a number to text, using a currency format.There is no equivalent Anaplan function, but can be built using a calculation.
DPRODUCTReturns the product of the numbers in a column in a list or database, based on the specified criteria.There is no equivalent Anaplan function, but can be built using a calculation.
DSTDEVReturns the standard deviation of a population based on a sample of numbers.There is no equivalent Anaplan function, but can be built using a calculation.
DSTDEVPReturns the standard deviation of a population based on the entire population of numbers.There is no equivalent Anaplan function, but can be built using a calculation.
DSUMSums the numbers in a column or database that meets the specified criteria.Use the SUM function.
DURATIONReturns the macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows. This is used as a measure of a bond price's response to changes in yield.Use the DURATION function.
DVARReturns the variance of a population based on a sample of numbers.Use the SELECT and COLLECT functions with line items to calculate the variance.
DVARPReturns the variance of a population based on the entire population of numbers.Use the SELECT and COLLECT functions with line items to calculate the variance.

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.