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 update Anapedia regularly to provide the most up-to-date instructions.