Count days between two dates excluding weekends

D

Donald Guillett

What formula should I use to count the # of days between 2 dates
excluding weekends?
Click to expand...
One way among many
=SUMPRODUCT((TEXT(G1:G10,"ddd")<>"Sat")*(TEXT(G1:G10,"ddd")<>"Sun"))
 
R

Ron Rosenfeld

What formula should I use to count the # of days between 2 dates
excluding weekends?
Click to expand...

=networkdays(start_date,end_date)

If you are using a version of Excel prior to 2007, and you get a #NAME error, goto HELP for the NETWORKDAYS function to see how to install the Analysis Tool Pak.

Note that this function counts BOTH the start and end dates, so depending on your requirements, you may need to subtract 1 from the result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting excluding weekends and holidays 1
Date + X days excluding holidays 1
Days between 2 dates excluding Sundays only 1
Calculating Days Between Dates 6
Business days code 4
calculate number of days formula 11
Material Costs spread across days. 0
Function: days of week in column, Excel 2000 & 2003 1

Top