Hi, has anyone found an alternative to Excel's YEARFRAC-Formula? The formula has various day count conventions such as Actual/Actual, US 30/360, Actual/360, etc. I am trying to get the year fraction for different time periods but it's quite complicated in Anaplan. Best, Evgenij
I have the same requirement/problem as Evgenij. It is a little more complicated than what Peter posted; those calcs are pretty accurate but when converting Excel models to Anaplan the finance types like to use the optional "basis" parameter to the YEARFRAC function, as shown here:
YEARFRAC calculates the portion of the year slightly differently for each of these different "basis" parameter values. I was hoping to find someone who had figured out how to do this in Anaplan, but it looks like I might have to blaze that trail... After I confirm with my client that this is essential, I will spend the time to figure it out and post my solution.