+ Reply to Thread
Results 1 to 4 of 4

VBA Code to calculate utilization of an Employee using Start & End Date

  1. #1
    Registered User
    Join Date
    03-07-2014
    Location
    new jersey
    MS-Off Ver
    Excel 2007
    Posts
    8

    VBA Code to calculate utilization of an Employee using Start & End Date

    Need help creating a formula that takes into account the employee start and end date and plugs in a value of 1 if the employee worked the entire month or a pro-rated value based on the number of months worked in that month over the number of business days in the month.

    Basically the formula has three criteria
    1. Formula must output a value of 1 for each month the employee has worked in entirety.
    2. If the start date begins mid month then the output is a calculation of number of days worked over number of business days
    3. If the end date lands mid month then the output is a calculation of number of days worked over number of business days.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: VBA Code to calculate utilization of an Employee using Start & End Date

    try the formulas
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-07-2014
    Location
    new jersey
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: VBA Code to calculate utilization of an Employee using Start & End Date

    thank you so much, I have been trying to create a formula for a few hours. Much appreciated.

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: VBA Code to calculate utilization ** an Employee using Start & End Date

    You are most welcome, please mark it as solved

+ 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. Calculate employee utilization based on billed hours
    By simrag01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2014, 04:48 PM
  2. [SOLVED] Employee Utilization for the Year based on Start Date and End Date
    By nickydharia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2014, 05:55 AM
  3. [SOLVED] Find start date and end date for the employee
    By Solomon14all in forum Excel General
    Replies: 2
    Last Post: 09-29-2012, 12:46 AM
  4. Replies: 2
    Last Post: 05-15-2009, 02:42 PM
  5. Replies: 4
    Last Post: 03-02-2009, 05:41 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