Thread
:
Determine weekday counts
View Single Post
#
1
Annabelle
Posts: n/a
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),"")
Reply With Quote