Conditional Statments

Hi All, I have tried to find solution to this problem for last few days with no success. I managed to get TodaysDate - 3 days using Today()-3 also I was able to extrct Name of the Day by using ...

Need Help

Show and Tell

ChrisMendoza

7 years ago

agatan -

I think I understand your issue, possibly below will aid in your solution.

ReAssigned Dates =
IF (
    WEEKDAY (
        Table1[Dates],
        2
    ) = 6,
    Table1[Dates] - 1,
    IF (
        WEEKDAY (
            Table1[Dates],
            2
        ) = 7,
        Table1[Dates] - 2,
        Table1[Dates]
    )
)

agatan
7 years ago
ChrisMendoza
Hi,
After your reasurment that the IF statment should work, I want to see what can cause the error.
There was few oter small issues but it is working now.
Big Thank You for your support!

Kind Regards,

Agata