# Excluding Weekends & Holidays

#### Jayker

##### New Member
Hey Excel'ers,

I am generating a spreadsheet that focuses on a target opening date. There is about 12 other headings along the top all stating the different phases of construction, permitting, etc. I need to exclude weekends and holidays from most of these columns, and only exclude holidays from about 2 of the columns. I think I am to use the formula for NETWORKDAYS, but not sure how or where to incorporate it.

Your help would be greatly appreciated.

Thanks,
Jay

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Welcome to MrExcel.

Did you look at Excel's Help topic for NETWORKDAYS or WORKDAY?

Welcome to MrExcel.

Did you look at Excel's Help topic for NETWORKDAYS or WORKDAY?

Yes I did. But I already have a formula on each cell. If I enter the target date, I have it so it will calculate each other heading based off the cell before it minus the amount of days it will take. Not sure how I incoporate NETWORKDAYS into the formula thats already there.

What formula do you have in the cell?

C5 is the column where my target date is.
Then at the last column (T) I have it so it takes the target date and subtracts 1 day =SUM(C5-1)
The second last column (S) subtracts 11 days so its =SUM(T5-11)
and so on..

Why are you using SUM when you aren't summing anything? Try =WORKDAY(C5,-1). You can add the holidays argument if you have a list of them.

Why are you using SUM when you aren't summing anything? Try =WORKDAY(C5,-1). You can add the holidays argument if you have a list of them.

I have a list of holidays in front of me. How do I incorporate that into the equation?

Thanks!

If your holidays are in A1:A10:

=WORKDAY(C5,-1,A1:A10)

If I list the holidays beside data I want to show, won't they print with it? Is there a way to list them in the document but not have them print?

You can put the holidays where you like, even on another sheet, eg:

=WORKDAY(C5,-1,Sheet2!A1:A10)

Replies
0
Views
119
Replies
3
Views
758
Replies
2
Views
226
Replies
3
Views
313
Replies
8
Views
2K

1,196,235
Messages
6,014,154
Members
441,807
Latest member
sjkenjalo

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

### Which adblocker are you using?

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

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