5 days a week not 7 (1 Viewer)

[steve111]

hi,
I have an "eventstart" field AND a " periodfreq " field , a drop down box with ( periodtypeid)
1. days , weeks , month, quarter , year

and I have " recurringcount" field

this then gives me an end date for the recurrence to fininsh
with this formula below

=IIf(([PeriodFreq] Is Null) Or ([PeriodTypeID] Is Null) Or ([RecurCount] Is Null),Null,DateAdd([PeriodTypeID],[RecurCount]*[PeriodFreq],[EventStart]))

at present it includes weekends,is it possible to change it so it does not include weekends

thanks
steve

 

[jdraw]

Research posts and google for "Workdays" or "Business Days".