How to calculate Completed Years for Employee

[johan.marketoft]

Hi,

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,

Johan

[JussiLi · Accepted solution]

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,

JussiLi