how can I void Saturday and Sunday 1

[112nokia]

Hi I am trying t0 calculate two working days (starting the system time)from thursday and Friday for one date field. Date()+2, seems to work for Monday to Wednesday, but on THursday and Friday I need the two working days, are taken into account when calculating the date field.

So for Monday to wednesdday, needs to be 2 calendaric days, and for 4 calendaric days( or in both cases 2working days).......many thanks in advance.

 

[PHV]

Provided this expression is never evaluated a saturday:
Date()+2-4*(Weekday(Date())>4)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[112nokia]

Unfortunately, Saturday is valuated on Thursday, ie Date()+2. For Thursday, the next date should be Monday.

 

[PHV]

Sorry for the typo. Try this:
Date()+2-2*(Weekday(Date())>4)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[112nokia]

Thank you it works!!