Saturday, August 30, 2014

Compute Number Of Months Employee Is projected To Work In Current Year

                      Google Spreadsheet   Post  #1741
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-28-2014
post by Gerry Potter:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/JgjHO1HVubw)
Number of Months
I am trying to write a formula in one cell (E4) that determines how many months an employee is forecasted to work for the company in the current year.  

C4 is the Hire Date of an employee
D4 is the End Date of an employee if the employee leaves the company in the current year or if they are forecasted to work through the end of the year "12/31/2014".

For instance if an employees' hire date is 5/15/2012 and they are forecasted to work through the end of the current year, the number of months returned in E4 would be 12.
       If an employees' hire date is 2/1/2014 and they are forecasted to work thru the end of the current year, the number of months returned in E4 would be 11.
       If an employees' hire date is 5/15/2012 but they leave the company on 7/1/14 then the number of months returned in  E4 would be 6.

Can you assist with a formula that I can have in E4 that will evaluate c4 and d5 to return the correct number of months in the current year?
---------------------------------------------------------------------------------------------------------------------------------