Formula needed

  • Thread starter Thread starter accessnovice
  • Start date Start date
A

accessnovice

I need a formula to figure out how many months an employee has worked since
the date of hire. Thank you in advance for your help.
 
accessnovice said:
I need a formula to figure out how many months an employee has worked since
the date of hire. Thank you in advance for your help.
Click to expand...

=DATEDIF(K1,TODAY(),"m")

where A1 holds the hire date.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Glad that you got it to work even although I messed up the example. I did
not notice that the top left cell was not A1 from working out a previous
formula.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top