>Hi,
>
>Has anyone had to work this one out before. Either how many work days between 2 dates or how many weekends between the 2 dates.
>
>Regards
>Doug Johnston

Assuming holidays doesn't matter :

lparameters tdD1, tdD2, tnWorkDaysInWeek
* First day of workday is Monday - 2
tnWorkDaysInWeek = iif(empty(tnWorkDaysInWeek),5,tnWorkDaysInWeek)
return floor(abs(tdD2-tdD1)/7) * tnWorkDaysInWeek + ;
  min(dow(max(tdD1,tdD2),2),tnWorkDaysInWeek) - ;
  dow(min(tdD1,tdD2),2) + 1

Cetin