How to calculate Completed Years for Employee

Frequent Contributor

How to calculate Completed Years for Employee

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

1 REPLY 1
Contributor

Re: How to calculate Completed Years for Employee

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