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.
the date of hire. Thank you in advance for your help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sandy Mann
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.
=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
[email protected]
Replace @mailinator.com with @tiscali.co.uk
A
accessnovice
Thank you so much for your fast response. Truly appreciate it. Have a great
day!
day!
S
Sandy Mann
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
[email protected]
Replace @mailinator.com with @tiscali.co.uk
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
[email protected]
Replace @mailinator.com with @tiscali.co.uk