+ Reply to Thread
Results 1 to 3 of 3

calculate what months an employee worked by start and end date

  1. #1
    Registered User
    Join Date
    05-15-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    calculate what months an employee worked by start and end date

    Hello,

    I am working on a sheet that will allow a user to enter a start month (from a pre-defigned drop down list) and an end month (again from ddl).

    What I need to calculate is in what months the employee worked in so I can calculate their salary cost by quarter.

    It can populate other cells in order to do the calculation if needed.

    So, for example if an employee started in May, and worked until December, I need to calculate that he worked 2 months in Q1, 3 months in Q2, 3 months in Q3, and 0 months in Q4.

    Our fiscal year is April to March.. ;-)

    I have thought of several options, but none of them have worked 100%.

    Hopefully someone here can help me...

    Thanks,
    Last edited by smck; 05-20-2009 at 02:48 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: calculate what months an employee worked by start and end date

    Welcome to the Board.

    I wonder if perhaps the attached is of any interest ?

    A sample file is often useful as it helps others visualise your setup and desired results.
    Attached Files Attached Files
    Last edited by DonkeyOte; 05-15-2009 at 12:26 PM.

  3. #3
    Registered User
    Join Date
    05-15-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: calculate what months an employee worked by start and end date

    Worked great, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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