View Single Post
  #1   Report Post  
Annabelle
 
Posts: n/a
Default Determine weekday counts

I'm trying to show the number of days between two dates. The formula
below works, but counts EVERY day. I just want the weekdays counted
(exclude Sat and Sun). Can you assist?

=IF(AND(E20<"",G20<""),DAYS360(E20,G20),"")