Hello all,
I would like your help to create a new column with a a calculated date.
I have a requested delivery date that for some circumstances need to be recalculated based on the route. To do this, depending on the route i need to rest certain working dates to the delivery date.
The issue here is that my date table includes "Saturday" and "Sunday" so i can't make a simple rest. I need to rest it to the working days. So if it is Monday, i couldn't rest 1 day simply as it would be sunday but need to rest 3 days.
Could you help me building the formulat to getthis new column ?
Much appreciated!
