Add only week days to Date 1

[mitmat]

Hello there
My formula so far is

if {TASKS.PRIORITY} = "low" then
{TASKS.OPENDATE} + 15 else

if {TASKS.PRIORITY} = "Medium" then
{TASKS.OPENDATE} + 5 else

if{TASKS.PRIORITY} = "High"
then
{TASKS.OPENDATE} + .33333

I realised after i submitted my report that our system doesn't use Weekends.
I've tried to find a solution to this with no joy
Any help would be Fab

 

[synapsevampire]

Check out:

http://www.kenhamady.com/form17.html

-k

 

[mitmat]

Thanks Synapsevampire