Results 1 to 4 of 4

Percent on Leave During Specific Range of Dates

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Korea
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Percent on Leave During Specific Range of Dates

    I am needing some help with a function. I would like to show a percentage in E2:E16 that represents the percentage on leave during the corresponding dates in B2:C16. For example: Row 5 dates are 4 Dec 12- 11 Dec 12, at that time there will be 3 other people on leave. I would like E5 to be represented by that percentage, which will be 3/92*100. I am trying to show at any given time and range the percent that will be on leave. I hope that I explained this well if not please let me know. I appreciate any and all help.
    Attached Files Attached Files

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