Discount days to a date

Anonymous · ‎09-02-2018

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 · ‎09-03-2018

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.