t+2 exclude weekend

[tchong95]

Hi all

I had already written a T+2 expression but now I would like it to skip to Monday if the product of T+2 falls on Saturday and Tuesday if it falls on Sunday.

How should I rewrite the formula?

addDays(utcNow(),2,'dd-MM-yyyy')

[tchong95 · Accepted solution]

figured it out

if(
    equals(
        dayofweek(
            addDays(utcNow(),2)),
            6),
            addDays(utcNow(),4,'dd-MM-yyyy'),
            if(
                equals(
                    dayofweek(
                        addDays(utcNow(),2)
                        ),
                        0),
                        addDays(utcNow(),4,'dd-MM-yyyy'),addDays(utcNow(),2,'dd-MM-yyyy'))
                        )