Working Days in DD/MM/YYYY format

[Sumit2504]

Hi All,

I want to calculate No of working days in DD/MM/YYYY format.

For example - My starting date is 01/Jan/2020 and Last date is 31/Jan/2020 so i want list of all working days in DD/MMM/YYYY.

Regards,

Sumit

[tresB]

Same load:

If(Not Match(WeekDay(Date),'Sat', 'Sun') And IsNull(ApplyMap('Map', Date,null())), Date) as WorkingDay,

Day(If(Not Match(WeekDay(Date),'Sat', 'Sun') And IsNull(ApplyMap('Map', Date,null())), Date)) as Day