Working Days excluding Sundays
=SUMPRODUCT(--(WEEKDAY(A2:A20)<1))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"danh" wrote in message
...
I have to calculate the no of days between 2 dates and exclude only sundays
in my count of days. I have tried NETWORKDAYS but it seems to exclude
saturdays and sundays. I only need to exclude sundays. Can somebody help
me?
Thanks
Danielle
|