week days

J

jhillock

New Member
Joined
Feb 11, 2005
Messages
4
how do you only include weekdays in a day calculation so only to count workdays
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
jhillock said:
how do you only include weekdays in a day calculation so only to count workdays
Click to expand...

=NETWORKDAYS(Date1,Date2,Holidays)

where Date1 <= Date2 and Holidays refers to a range which house relevant holiday dates. Holidays is optional.

The function requires the Analysis Toolpak add-in.
 
Upvote 0
thanks!


how about if you have a start date and a duration and you want to calculate the end date excluding weekends and holidays?
 
Upvote 0
jhillock said:
thanks!


how about if you have a start date and a duration and you want to calculate the end date excluding weekends and holidays?
Click to expand...

=WORKDAY(Date,DurationInDays,Holidays)
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Day of week in an excel form
2
Replies
10
Views
272
My Aswer Is This
My Aswer Is This
mjones
  • Question
Add one to day of week
Replies
6
Views
156
awoohaw
awoohaw
M
  • Solved
Add # of days but exclude only specific days
Replies
3
Views
142
Fluff
Fluff
I
  • Solved
Find the Next non-Holiday Monday from a given date?
Replies
4
Views
380
Fluff
Fluff
Z
  • Solved
Conditional Format Date Range
Replies
4
Views
357
zero269
Z

Forum statistics

Threads
1,206,920
Messages
6,075,573
Members
446,147
Latest member
homedecortips

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top