How to add Saturday, Sunday or Public Holiday if the value is blank

[Fathopes]

Hi All,

I have the table like below, how can I add saturday, sunday or Public Holiday inside this table if the value is blank. Attached also the example of excel the answer I want.

Thanks and Regards,

Fathopes.

[Anonymous · Accepted solution]

Hi @Fathopes ,

Basically you will need a table contains dates with weekends and holidays.

For exmaple:

Table1:

Table2:

Then add a column.

Column =
IF (
    ISBLANK ( Table1[value] ),
    LOOKUPVALUE ( Table2[weekends or holidays], Table2[days], Table1[days] ),
    FORMAT ( Table1[value], "" )
)

Best Regards,

Jay