Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 14
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,345
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 14
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula needed please jackrobyn1 Excel Discussion (Misc queries) 2 June 5th 08 11:50 AM
Formula Needed AshMorK Excel Discussion (Misc queries) 0 January 30th 08 06:09 PM
Formula help needed [email protected] Excel Worksheet Functions 0 May 24th 06 07:13 PM
Formula Needed... Steven Sinclair Excel Worksheet Functions 15 December 16th 05 02:41 PM
Formula needed. Beertje Excel Discussion (Misc queries) 7 November 29th 05 09:54 AM


All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"