Business date calculation

[ER]

Does anyohe have thoughts on how to create a calulation for 10 business days?

[Lee Smith]

You need a Number field (I called it PlusBusDays)

and a Calculation Field with a Date Result with this Calculatioln:

YourDateField + Int(PlusBusDays/5) * 7 + Middle("12345012340123601256014560345623456", (DayofWeek(YourDateField) - 1) * 5 + Mod(PlusBusDays,5) + 1, 1)

HTH

Lee

[-Queue-]

Or just dateField + 14, if dateField will never have a weekend date entered. Otherwise,

dateField + 14 + Position( "17"; DayOfWeek(dateField); 0; 1 )