Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Workday Function (Friday as Weekend)

  1. #1
    Join Date
    10th February 2005
    Posts
    12

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th July 2004
    Posts
    1,319

    Re: Workday Function (Friday as Weekend)

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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    10th February 2005
    Posts
    12

    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..

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    15th October 2003
    Posts
    160

    Re: Workday Function (Friday as Weekend)

    Not quite sure but does this help you.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    10th February 2005
    Posts
    12

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,304

    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

  7. #7
    Join Date
    10th February 2005
    Posts
    12

    Re: Workday Function (Friday as Weekend)

    kris,

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

    cheers.

    dred

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,304

    Re: Workday Function (Friday as Weekend)

    Quote Originally Posted by dredbluz
    kris,

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

    cheers.

    dred
    You are welcome!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Workday Function use in VBA
    By Burlone_Ubriaco in forum EXCEL HELP
    Replies: 7
    Last Post: August 15th, 2006, 22:09
  2. WORKDAY Function
    By Dinger13 in forum EXCEL HELP
    Replies: 1
    Last Post: March 9th, 2005, 02:14
  3. Setting Date format using VBA Workday Function
    By adncmm1980 in forum EXCEL HELP
    Replies: 3
    Last Post: January 10th, 2005, 20:56
  4. VBA : using the workday function with vba
    By tvsmvp in forum EXCEL HELP
    Replies: 3
    Last Post: March 24th, 2004, 23:07
  5. workday function in VB
    By AdamK in forum OPEN SOURCE: Hey! That is Cool!
    Replies: 0
    Last Post: May 31st, 2003, 02:15

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
  •  
porno