Announcement

Collapse
No announcement yet.

Workday Function (Friday as Weekend)

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

  • Workday Function (Friday as Weekend)



    hey guys,

    i'm really out of depth in trying to figure out how to make the function workday to exclude FRIDAYS instead of Saturdays and Sundays. I'm working here in the middle east and friday is our rest day. Is there any way to do it in excel?

    il really appreciate any help.

    dred

  • #2
    Re: Workday Function (Friday as Weekend)

    I think you will have to try and combine with the WEEKDAY function

    Comment


    • #3
      Re: Workday Function (Friday as Weekend)

      thanks for the reply. would you care to show the formulas. i'm really stuck up in this.

      thanks again..

      Comment


      • #4
        Re: Workday Function (Friday as Weekend)

        Not quite sure but does this help you.
        Attached Files

        Comment


        • #5
          Re: Workday Function (Friday as Weekend)

          hi gizzmo,

          almost but not quite. I'm working on project scheduling using excel. I mean the time frame is variable (ie. 1, 3, 5 or 14 months.). in that formula, i have to list all fridays. lets say i will start at jan 1, 2006, and the project must be finished at 30 working days. Rest day is friday. For that, project must be accomplished on February 4, 2006.

          Thanks again.

          Comment


          • #6
            Re: Workday Function (Friday as Weekend)

            Hi,

            There may be a better solution, but this works,

            =A1+A2+SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A1+A2)))=6))

            where A1 houses the start date, A2 houses the time frame.

            HTH
            Kris

            ExcelFox

            Comment


            • #7
              Re: Workday Function (Friday as Weekend)

              kris,

              thanks a lot kris. this is exactly what i need.

              cheers.

              dred

              Comment


              • #8


                Re: Workday Function (Friday as Weekend)

                Originally posted by dredbluz
                kris,

                thanks a lot kris. this is exactly what i need.

                cheers.

                dred
                You are welcome!!
                Kris

                ExcelFox

                Comment

                Working...
                X