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
0
Comments
-
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
0