J JGGL Feb 18, 2011 #1 What formula should I use to count the # of days between 2 dates excluding weekends?
D Donald Guillett Feb 18, 2011 #2 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"))
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"))
