Comparisons of Microsoft Excel functions to those available in Anaplan.

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.