Formula needed
 

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.

Formula needed
 

"accessnovice" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"accessnovice" wrote in message
...
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.

Formula needed-solved
 

Thank you so much for your fast response. Truly appreciate it. Have a great
day!

"Sandy Mann" wrote:

"accessnovice" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"accessnovice" wrote in message
...
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.

Formula needed-solved
 

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


Replace @mailinator.com with @tiscali.co.uk


"accessnovice" wrote in message
...
Thank you so much for your fast response. Truly appreciate it. Have a
great
day!

"Sandy Mann" wrote:

"accessnovice" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"accessnovice" wrote in message
...
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.