LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kim
 
Posts: n/a
Default Length of employment

I would like to set up a formula to calculate duration of employment from
Hire Date to Review Date and show results in Years and Months. The date of
hire is in one column and review date in another column. Example: January 1,
2001 to June 30, 2005 with the result being 4 years, 6 months. Thanks for
any help.
 
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
Graph with variable data length snoach Excel Discussion (Misc queries) 1 May 27th 05 10:15 AM
formula to standarize cell length JT Excel Worksheet Functions 1 May 24th 05 09:42 PM
Filename length in Excel limited to 92 characters PARaine Excel Discussion (Misc queries) 4 May 8th 05 07:57 PM
Hyperlink Length Jason Excel Worksheet Functions 0 January 14th 05 05:49 PM
list box length Larry M Excel Worksheet Functions 2 November 24th 04 12:17 AM


All times are GMT +1. The time now is 08:04 AM.

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"