Hello there,
I use
DATEPART('day',[Referral Date])<>1 and DATEPART('day',[Comp Assessment])<>7
to calculate # of working days between two days, however I got the T|F options instead of the # of working days.
Any idea to let me know what I missed is highly appreciated.
Thanks!
6 answers
The following KB article shows you how to calculate the number of weekdays between two dates: Calculating Number of Weekdays Between Dates