Announcement

Collapse
No announcement yet.

Date Difference Without Weekends

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Date Difference Without Weekends



    Good day,

    I have searched google and many forums and cannot find out what formula I can use to calculate the difference between two dates while not including weekends. For example in cell A1 I have 27-Feb-07 and in B1 I have 05-Mar-07 ; it is possible to to calculate the difference between these by not including weekends. The weekends I am refering to are Saturday and Sunday.

    Thank you for your help,

    Chris

  • #2
    Re: Date Difference Without Weekends

    Yes... special function in Excel called:

    NETWORKDAYS

    use like =Networkdays(Start,Finish,Any Holidays)

    Check out the Excel Help on it for more information.

    You must add the "Analysis Tool Pak" to access this function (from the Tools/Add-in Manager).

    Ger
    Last edited by Ger Plante; March 15th, 2007, 23:27.

    Check out our new reputation system. Click on the "star" under the post!
    _______________________________________________

    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

    Comment


    • #3
      Re: Date Difference Without Weekends

      Thank you for your respone.
      I enter =Networkdays(B135,C135) in the cell and received the #Name? message. Do you have to enter the "Any Holidays" section although there isn't any?

      Thank you,

      Comment


      • #4
        Re: Date Difference Without Weekends

        Like I said - you MUST have the Analysis Tool Pak added in...

        Go to Tools/Add-In and check to make sure "Analysis ToolPak" is there.

        Ger

        Check out our new reputation system. Click on the "star" under the post!
        _______________________________________________

        There are 10 types of people in the world. Those that understand Binary and those that dont.

        Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

        The BEST Lookup function of all time

        Dynamic Named Ranges are your bestest friend

        _______________________________________________

        Comment


        • #5
          Re: Date Difference Without Weekends

          Check also to make sure the two cells that are references are valid dates and formatted as a date.

          Thanks,
          Ger

          Check out our new reputation system. Click on the "star" under the post!
          _______________________________________________

          There are 10 types of people in the world. Those that understand Binary and those that dont.

          Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

          The BEST Lookup function of all time

          Dynamic Named Ranges are your bestest friend

          _______________________________________________

          Comment


          • #6
            Re: Date Difference Without Weekends

            My bad, I did't have the add-in added.
            Sorry about that.
            If you have 27-Feb-07 in A1 and in B1 you have 05-Mar-07 , wouldn't the differene be 4, considering the DateDiff function between those dates are 6? Because the networkdays function is giving me 5.

            Comment


            • #7
              Re: Date Difference Without Weekends

              Well... whats a day between friends

              Seriously, the Networkdays function counts the first day as a date...

              if start date and end date are the same (27 Feb), it will return 1, whereas you might expect it to be zero.

              In otherwords, its an inlclusive function.

              Ger
              Last edited by Ger Plante; March 15th, 2007, 23:44.

              Check out our new reputation system. Click on the "star" under the post!
              _______________________________________________

              There are 10 types of people in the world. Those that understand Binary and those that dont.

              Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

              The BEST Lookup function of all time

              Dynamic Named Ranges are your bestest friend

              _______________________________________________

              Comment


              • #8


                Re: Date Difference Without Weekends

                Makes sense.

                Thank you.

                Comment

                Working...
                X