Ok Thanks that worked :-)
Now one last problem, If I change the date to 5 for weekend for some reason it does not work properly. Seems again to be counting all dates, including blanks.
I did change the display options and that worked.
=SUMPRODUCT(--(WEEKDAY(A$2:A$32,2)5),D$2:D$32)/SUMPRODUCT(N(WEEKDAY(A$2:A$32,2)5))
Thanks for all the help :-)
|