Comparisons of Microsoft Excel functions to those available in Anaplan.
Excel comparison: D functions
| Excel function | Excel description | Anaplan solution |
| DATE | Returns 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. |
| DATEDIF | Returns 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. |
| DATEVALUE | Returns the serial number of a date. | Use Date Settings. |
| DAVERAGE | Averages all numbers in a column in a list or database, based on specified criteria. | Use the x[AVERAGE]:y aggregation function. |
| DAY | Returns 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. |
| DAYS | Returns 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. |
| DAYS360 | Returns 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. |
| DB | Returns the depreciation of an asset based on the fixed-declining balance method. | See the Financial Functions. |
| DCOUNT | Returns the number of cells in a column or database that contains numeric values and meets the given criteria. | Use the SUM function. |
| DCOUNTA | Returns the number of cells in a column or database that contains nonblank values and meets the given criteria. | Use the SUM function. |
| DDB | Returns the depreciation of an asset based on the double-declining balance method. | See Financial Functions. |
| DEGREES | Converts radians to degrees. | There is no equivalent Anaplan function, but can be built using a calculation. |
| DGET | Retrieves from a database a single record that matches the given criteria. | Use the ITEM function. |
| DMAX | Returns the largest number in a column in a list or database, based on the specified criteria. | Use the MAX function. |
| DMIN | Returns the smallest number in a column in a list or database, based on the specified criteria. | Use the MIN function. |
| DOLLAR | Converts a number to text, using a currency format. | There is no equivalent Anaplan function, but can be built using a calculation. |
| DPRODUCT | Returns 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. |
| DSTDEV | Returns 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. |
| DSTDEVP | Returns 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. |
| DSUM | Sums the numbers in a column or database that meets the specified criteria. | Use the SUM function. |
| DURATION | Returns 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. |
| DVAR | Returns the variance of a population based on a sample of numbers. | Use the SELECT and COLLECT functions with line items to calculate the variance. |
| DVARP | Returns 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 content regularly to provide the most up-to-date instructions.