Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Check out
http://www.cpearson.com/excel/datedif.htm at Chip Pearson's website for guidance. "Kim" wrote: 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. |
#3
|
|||
|
|||
See:
http://www.cpearson.com/excel/datedif.htm Regards, Peo Sjoblom "Kim" wrote: 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. |
#4
|
|||
|
|||
You can use this formula with the dates in D5 and E5
=IF(D5<=E5,DATEDIF(D5,E5,"Y") & " y " & DATEDIF(D5,E5,"ym") & " m","-"&DATEDIF(E5,D5,"y")& " y " &DATEDIF(E5,D5,"ym")& " m") See this add-in for a easy way to insert formulas in your table http://www.rondebruin.nl/datarefiner.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Kim" wrote in message ... 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. |
#5
|
|||
|
|||
Thank you! It is perfect! You just saved us SO much time and work!
"Duke Carey" wrote: Check out http://www.cpearson.com/excel/datedif.htm at Chip Pearson's website for guidance. "Kim" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph with variable data length | Excel Discussion (Misc queries) | |||
formula to standarize cell length | Excel Worksheet Functions | |||
Filename length in Excel limited to 92 characters | Excel Discussion (Misc queries) | |||
Hyperlink Length | Excel Worksheet Functions | |||
list box length | Excel Worksheet Functions |