How to calculate Completed Years for Employee

johan.marketoft
johan.marketoft
in Academy Discussions

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

Comments

  • JussiLi
    JussiLi

    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

Categories