How to count number of days excluding weekends

[steveo250k]

Using the new "Calulcated Fields", I'm trying to calculate the number days between specific dates without counting weekends. Right now, I'm using the below IF statement but I want to exclude weekends. Please help.

IF(ElapsedDays("Origin Arrival Date Date", "Ready Date") >= 3, 'DELINQUENT')

[djohnson53]

Well,  for brevity, 

where  a week is Mon=1,Tues=2,Wed=3,Thu=4,Fri=5,Sat=6,Sun=7

(pseudo-code)

if ( Date is Mon or Tues) and ElapsedDays>=3, then "DELINQUENT"     /*  No Weekend

else if ElapsedDays>=5 then "DELINQUENT"                                          /* Weekend in middle - add two days.

 

I'm assuming that you won't start this ON the weekend.