Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Workday Function (Friday as Weekend)

1. I agreed to these rules
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. ## 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. I agreed to these rules
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. Senior Member
Join Date
15th October 2003
Posts
188

## Re: Workday Function (Friday as Weekend)

Excel Video Tutorials / Excel Dashboards Reports

5. I agreed to these rules
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. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,682

## 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. I agreed to these rules
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. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,682

## 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!!

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

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