+ Reply to Thread
Results 1 to 3 of 3

Headcount Model with Start and End Dates by Quarter Excel lookup on number of employees

  1. #1
    Registered User
    Join Date
    07-28-2021
    Location
    san diego, ca
    MS-Off Ver
    Windows 10
    Posts
    1

    Headcount Model with Start and End Dates by Quarter Excel lookup on number of employees

    Question: Using an excel graph show the number of FTEs for the total company by quarter by year since the beginning of time.[/B]

    How would you go about this on excel assuming you only have start and end dates? Is there any easy formula, that someone can help write for calendar quarters? Do they want me to show net headcount each quarter since they provided the start and end dates?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    23,961

    Re: Headcount Model with Start and End Dates by Quarter Excel lookup on number of employee

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,539

    Re: Headcount Model with Start and End Dates by Quarter Excel lookup on number of employee

    Your Office version is not Windows 10 - that’s your OS.

    Please update your forum profile accordingly.

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Replies: 4
    Last Post: 06-15-2022, 11:30 AM
  2. Replies: 0
    Last Post: 10-15-2019, 12:56 AM
  3. Replies: 2
    Last Post: 03-05-2018, 03:50 AM
  4. Conducting headcount based on number of employees working a specific shift
    By joannechen101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2017, 01:47 PM
  5. Replies: 13
    Last Post: 06-04-2015, 01:56 AM
  6. Restrict Input Start and End Dates to One Quarter
    By Gos-C in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2012, 03:08 PM
  7. Excel 2007 : Calculating Quarter Start Dates
    By mlh4041 in forum Excel General
    Replies: 2
    Last Post: 10-19-2009, 10:26 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