Discount days to a date

[Anonymous]

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!

[v-yulgu-msft]

Hi @Anonymous,

Not very clear about your requirement. Please illustrate with some dummy data and desired output.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu