How to calculate Completed Years for Employee




I am wondering how to go about calculating the number of years completed at a company by an employee based on their start date. I can see ways doing this but doesn't seem very PLANS, can someone please advice on it or link to micro lesson for example?


Best regards,



  • Hi @johan.marketoft

    I would use YEARFRAC function for that. And put it inside ROUND function to get the number of full years. 


    I case you want to compare employee start date to current date that might be trickier because Anaplan doesn't have a function to give you current date (like NOW() function in Excel). 

    You need to import current date from outside Anaplan. 


    Best regards,