Results 1 to 2 of 2

Thread: Want formula to return average days between two dates in a given month

  1. #1

    Want formula to return average days between two dates in a given month



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi guys,

    First post and it's going to be a complicated one to explain!

    I have a workbook with two sheets. The first has a list of job positions open, columns designated to stages in the employment process and in these columns, my staff enter the dates that they completed a particular stage.

    "Position | Date Opened | Stage 1 | Stage 2 | Stage 3 | Stage 4"
    Pos 1 | 01/01/2014 |02/01/14|03/01/14|07/01/14|09/01/14

    This has a great number of entries and they are increasing and decreasing every day depening on the amount of jobs available.

    On the second sheet, I am trying to set up a table which shows the average working days it is taking to complete each stage, divided into the months in which the job position was opened (i.e. for positions opened in january, the average completion working days for stage 1 was X amount of days etc...)

    I have tried using =IF(AND(Logical, Logical),TRUE,FALSE) but this doesn't return any info as the logicals will always be false. I tried the OR function, but that requires only one of the criteria to be true to return a value. What I need is for the formula to return a number of days between two dates, ONLY if the opened date falls in one month.

    Any assistance on this would be greatly appreciated!

    -Abid

  2. #2
    Conjurer Rudi's Avatar
    Join Date
    Jan 2014
    Location
    Cape Town, RSA
    Posts
    131
    Articles
    0
    Excel Version
    Excel 365 ProPlus

    Average Workdays

    Without knowing what the table on Sheet 2 looks like I have to improvise.
    How about something like the attached?
    If it is not what you are after, hopefully the formulas will help you get to some acceptable solution.

    Attachment 1964

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •