One way

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(E8&":"&E9)),2)=5))

totals 5 which is correct

to get the non fri-sun days use

=1+E9-E8-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(E8&":"&E9)),2)=5))

format as general or else you probably get a weird date


--

Regards,

Peo Sjoblom

"Simon Heaven" <Simon wrote in message
...
Hi, I have two dates (E8 = 17/02/05 & E9 =26/02/05).
I want to know how many days in that range are Fridays, Saturdays or
Sundays
as I am building a work schedule to calcuate days not worked and men only
work Mon to Thursday.
I need to use standard excel functions as the workbook must be compatiable
on all computer (even without toolpak installed).
Any idea would be appreciated.

Thanks