Results 1 to 2 of 2

Pivot table for a number of employees by month

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2024
    Location
    MI
    MS-Off Ver
    365
    Posts
    1

    Pivot table for a number of employees by month

    Getting frustrated trying to create a pivot table for a number of employees by month. I am trying to generate what the number of active employees by month (whether active or terminated)

    Even better would be for the pivot table to count both active and inactive employees by month.

    12/2020 = 1 active employee
    1/2021 = 7 active employees (6 new hires and 1 from previous month)
    2/2021 = 18 active employees (21 new hires and 3 terminated)
    etc.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 12-14-2022, 07:20 AM
  2. Replies: 3
    Last Post: 05-05-2022, 05:00 PM
  3. [SOLVED] Formula t count number of employees for each month
    By rizmomin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-07-2020, 05:32 PM
  4. Replies: 10
    Last Post: 07-27-2017, 12:44 PM
  5. Count Number of Employees Per Month Using Pivot Table Excel 2010
    By mclarke in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2017, 08:56 AM
  6. Count Number of Employees Per Month Using Pivot Table Excel 2010
    By mclarke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2017, 04:21 PM
  7. PIVOT - Number of employees per month
    By obionenairobi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-26-2015, 08:39 AM

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