Comparisons of Microsoft Excel functions to those available in Anaplan.

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


Excel functionExcel descriptionAnaplan solution
YEARReturns a four-digit year (a number from 1900 to 9999) given a date value.Use the YEAR function to convert a date or a time period to a year in a number format.
YEARFRACCalculates the fraction of the year, represented by the number of whole days between two dates.Use the YEARFRAC function.
YIELDReturns the yield on a security that pays periodic interest.Use the YIELD function.