Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Location
    Ellettsville, Indiana, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    counting with dates (2000)

    I have a list of different departments with each employee and the dates they started working at that department. I need to break down employees that have been working from 0-2 years, 2-4 years 5-7 years etc. then count the number of times those groups apear in each department. HELP

  2. #2
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: counting with dates (2000)

    Not very accurate but.....

    =DATEDIF(A1,TODAY(),"Y")

    Where A1 houses the start date

    Then use COUNTIF

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: counting with dates (2000)

    In which group do employees belong that have been working for 2 years? You mention 0-2 and 2-4 years.

  4. #4
    Star Lounger
    Join Date
    Oct 2001
    Location
    Ellettsville, Indiana, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: counting with dates (2000)

    it varies. HR might have some from group 1 (0-2) and group 2 (2.1-4) and so on.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: counting with dates (2000)

    You can use the FREQUENCY worksheet function. In the attached example, I have calculated the years of employment using the DATEDIF function. Column I contains the upper limits of the intervals; column J contains the frequencies in the form of an array formula (entered with Ctrl+Shift+Enter) using FREQUENCY.

Posting Permissions

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