Calculating time-frame (days) between 2 dates excluding weekends/holidays

Hello and welcome to the forum. Yes, the NETWORKDAYS function counts the number of workdays between two dates excluding weekends and holidays.

Assuming that your dates are in column A and B and a list of holidays are in cells G2:G10, you can use something like this:

=NETWORKDAYS(A2,B2,G$2:G$10)
Drag the formula down

Note that the result includes the start and end dates as long as they are not on a weekend or holiday.

See here for more info on the NETWORKDAYS function.

Thank you 63falcondude, that helped! The values that I'm getting are counting the RECV_DATE, for example, if the RECV_DATE is 4/5/18 and the SHIP_DATE is 4/7/18, it is showing the value as 3 days instead of 2... is there a way to make a command in the formula to subtract a day? The time between those two days should be showing 2, in my opinion, and not 3.

Sure, that would be as simple as this:

=NETWORKDAYS(A2,B2,G$2:G$10)-1

You are the man!! Thank you so much.

You're very welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.