+ Reply to Thread
Results 1 to 2 of 2

Formula for Calculating Dates between certain time period

  1. #1
    Registered User
    Join Date
    04-06-2015
    Location
    Anaheim Hills, CA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3

    Formula for Calculating Dates between certain time period

    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.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Formula for Calculating Dates between certain time period

    This will give you 'complete months'. ie I have to put the 1 May not 30 April in to ensure it captures all of April

    Assuming your start date is in column A and your finish date is in column B.

    =DATEDIF(MAX(A3,DATE(2000,1,1)),MIN(B3,DATE(2006,4,30)),"M")
    Happy with my advice? Click on the * reputation button below

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating APR over a period of variable time.
    By Shady Shadrack in forum Excel General
    Replies: 4
    Last Post: 03-03-2015, 06:49 PM
  2. [SOLVED] Divide Time Period across different Time Frames (Calculating Interest)
    By kopapa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2013, 03:09 PM
  3. Calculating data within a time period
    By jmorton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2012, 10:31 AM
  4. Calculating Time across a 24 hour period
    By jmag in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-19-2007, 12:27 PM
  5. [SOLVED] calculating elapsed time over a period of days
    By Jerome Ranch in forum Excel General
    Replies: 2
    Last Post: 05-13-2006, 12:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1