Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| YEAR | Returns 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. |
| YEARFRAC | Calculates the fraction of the year, represented by the number of whole days between two dates. | Use the YEARFRAC function. |
| YIELD | Returns the yield on a security that pays periodic interest. | Use the YIELD function. |
