I need to calculate the amount of months employees have been employed by my firm but I only want to include a certain time period:
I only want to include the months between 01/01/2000 and 04/30/2006
My spread sheet has a column of employment start dates (ranging from 02/28/1995 to 12/31/2004) and employment end dates (ranging from 06/30/2002 to Present)
For example Employee A Start Date- 01/01/2000 Employee end date (present) = 76 months (based on only the relevant time period)
Any suggestions of what formula I should use and how to word it.
Bookmarks