View original (French)

Excel: Calculate years of experience

Minaka -  
Marc Harnist Posted messages 94 Status Member -
Hello,

I need to fill in a column indicating the number of years of experience for candidates. However, we need that the column evolves with the years. I am not very experienced with Excel; I am just starting out. So I would like some help on which formula to use. I tried to go with logic, to find a way to subtract the year of starting work from the current year, but I don't know where to go.

Thank you in advance for your valuable help!

Configuration: Windows 7 / Safari 534.13

4 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Good evening,

    With the start date (dd/mm/yy) in A1:
    =ROUND((TODAY()-A1)/365.2,1)

    eric
    3