Extract data with excluding holidays

[rupaliqlik]

Hi,

I have one file where i extract data from it with T-1  filter.But on monday I extract it with T-2 .As per user's requirement they do not include sundays data or any holidays data(eg.,Public holiday,Independance day,festivals).So currently I'm doing this process manually but I want to schedule this report.Please help me in this kind of scenario.Please find attached sample data.

Regards,

Rup

stalwar1‌ kaushik.solanki‌ rwunderlich‌

[rupaliqlik]

Dear Antonio,

Data should be come for 14th august.In india Today is 16th August and My user want to see only Working days data.On 15th august we have holiday.

[antoniotiman]

Try this,

LOAD ID,USERNAME,
// DATE(DATE#(LEFT(Date,10),'YYYY-MM-DD'),'DD/MM/YYYY') AS DATE,
  Date(Floor(Date)) as DATE,
Branch
FROM
SAMPLE.xlsx
(ooxml, embedded labels, table is Sheet1)
WHERE If(Text(WeekDay(Today(0)))='Mon' or Exists(HOLIDAYLIST,Today(0)-1),
Date(Floor(Date))=Date(Today(0)-2), //on monday
Date(Floor(Date))=Date(Today(0)-1)) //on week days
and Not Exists(HOLIDAYLIST,Date(Floor(Date)));