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
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.

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.