Hi!

Try this array formula entered with the key combo of
CTRL,SHIFT,ENTER:

=SUM(N(WEEKDAY(ROW(INDIRECT(E8&":"&E9)))={1,5,6}))

Biff

-----Original 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
.