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"))
 

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

Calculating Days Between Dates 6
Function: days of week in column, Excel 2000 & 2003 1
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Conditional formatting excluding weekends and holidays 1
Date + X days excluding holidays 1
How do I calcluate networkHOURS? 1
Network days 1
Insert dates from a userform 4

Top