In reply to [email]b681fca9.0309032303.60d05da5posting.google.com[/email] on 9/4/03 12:03
AM by inzane [email]inzane2pac-outlawz.com[/email]:
Try this one.
creation date + Int(Time frame/5) * 7 +
Middle("12345012340123601256014560345623456", (DayofWeek(creation date) - 1)
* 5 + Mod(Time frame, 5) + 1, 1)
> I have a creation date field.
> A Approx Time frame field.
> Then a Approx Finish Date field.
> I can get it to add the correct amount of days to the creation date
> but i dont want it to count the weekends. Does anyone have or know the
> formula i should put in the calculation.
> Regards Michael.