I've had it before, but can't find it.

basically something like this --

DateDiff("w", StartingDate, EndingDate)


that also makes sure date is not in tblHolidays.
anyone knows how to acomplish this ?

i found it; here it is

# of Days Stale: DateDiff('d',[date],Date())-(DateDiff('ww',[Date],Date())*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between [date] and date())