Excluding Weekends & Holidays

[Jayker]

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

 

[Andrew Poulsom]

Welcome to MrExcel.

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

 

[Jayker]

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.

 

[Andrew Poulsom]

What formula do you have in the cell?

 

[Jayker]

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

 

[Andrew Poulsom]

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.

 

[Jayker]

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!

 

[Andrew Poulsom]

If your holidays are in A1:A10:

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

 

[Jayker]

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?

 

[Andrew Poulsom]

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

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