With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.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?