skip weekend dates

[WHYDO4399]

Hello to everyone.
I have a report where I am looking at to provide a data 3 days out from the release date. However if the release date is for example Friday... I want to start the 1 data at Monday. I never want it to start counting Saturday or Sunday.

Is there an easy way to do this?
Thx,

 

[lbass]

As long as the releasedate can never be a Saturday or a Sunday, the following should work, although it doesn't account for holidays:

if dayofweek({table.releasedate}) > 3 then
dateadd("d",5,{table.releasedate}) else
dateadd("d",3,{table.releasedate})

-LB