Calculate number of days, excluding weekends and holidays

**cloyd** · 11-26-2012, 04:14 PM

I am using the formula below to calculate the number of business days that have elapsed since a specific date. I would also like to account for the major holidays that might happen to fall within a date range. Can anyone help me add this piece to the formula below (or change the formula if there is an easier way to do it)? Please see example below

=NETWORKDAYS(M5,MIN(N5,TODAY()))
Excel Example.xlsx

Thanks in advance for the help!

**dogberry** · 11-26-2012, 04:17 PM

Hi

The formula will do it for you if you click on the fx on the formula bar it gives you the layout all you need to do is add the holiday dates as a range and refer to that

Chris

**JieJenn** · 11-26-2012, 04:18 PM

Like this?

**cloyd** · 11-26-2012, 04:23 PM

Chris,

I created a range of dates with all of the holidays I want to account for, but I must be putting it in the wrong place. When I put in a reference to those cells, it gives me a negative number. Can you write a quick example of where in the formula I would put that reference?

**cloyd** · 11-26-2012, 04:27 PM

JieJenn,

I didn't use that formula because I want to be able to leave the "Closed" date blank and have it keep a running count of the elapsed days. If the "Closed" date is blank with your formula, it gives me a negative number.