Thread: Count days between two dates excluding weekends
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Donald Guillett Donald Guillett is offline
external usenet poster
  
Posts: 36
Default Count days between two dates excluding weekends
On Feb 18, 3:44*pm, JGGL wrote:
What formula should I use to count the # of days between 2 dates
excluding weekends?
One way among many
=SUMPRODUCT((TEXT(G1:G10,"ddd")<"Sat")*(TEXT(G1:G 10,"ddd")<"Sun"))
Reply With QuoteReply With Quote