Forum Discussion

agatan's avatar
agatan
Frequent Visitor
7 years ago
Solved

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's avatar
    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's avatar
    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

rocky09's avatar
rocky09
Solution Sage
7 years ago

Can you provide some sample data. So, I can try for a solution.

agatan's avatar
agatan
Frequent Visitor
7 years ago

Hi Rokcy09 ,

 

Please find sample data:

 

 

 

 

 

Kind regards,

 

Agata