In article <[email protected]>,
[email protected] says...
> I need to count the number of Fridays in a range of dates, e.g. how many
> Fridays between 14 June 05 and 29 June 05 (including these two days). I'd be
> very grateful for your help.
>
=INT((Finish-Start)/7)+IF(OR(WEEKDAY(Start-6)>WEEKDAY(Finish-6),WEEKDAY
(Finish)=6),1,0)

seems to work!