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.

In reply to b681fca9.0309032303.60d05da5@posting.google.com on 9/4/03 12:03
AM by inzane inzane@2pac-outlawz.com:

Hi Michael,

Try this one.

creation date + Int(Time frame/5) * 7 +
Middle("12345012340123601256014560345623456", (DayofWeek(creation date) - 1)
* 5 + Mod(Time frame, 5) + 1, 1)

HTH

Lee

> 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.