Answered

How to count no of working days

(0) Share

Report

Posted on by venky232

i have 1 date picker, when user select date - it should show count of working days excluding weekends & holidays in that selected month.
holidays stored in Collection as

ClearCollect(Holidays,

{Date1:7/24/2023,Type:Pioneer Day},

etc......

Categories:

General Questions

All responses (2)

Answers (1)

venky232 on at

Like (0)

Report

Re: How to count no of working days

but it is not excluding holidays list from collection

ClearCollect(
Col_Holidaylist,
Table(
{Date1: Text(DateValue("16-Jan-2023"), "d-mmm-yyyy"), Type: "Optional Holiday"},
{Date1: Text(DateValue("26-Jan-2023"), "d-mmm-yyyy"), Type: "Company Holiday"},
{Date1: Text(DateValue("8-Mar-2023"), "d-mmm-yyyy"), Type: "Optional Holiday"},
{Date1: Text(DateValue("22-Mar-2023"), "d-mmm-yyyy"), Type: "Optional Holiday"},
{Date1: Text(DateValue("4-Apr-2023"), "d-mmm-yyyy"), Type: "Optional Holiday"}
{
)
);
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Re: How to count no of working days

Hi @venky232 ,

The Collection you offered.
Text of TextLabel:
With( { varDateRange: ForAll( Sequence(31,1), Text(Month(DatePicker1.SelectedDate) & "/" & Value & "/" & Year(DatePicker1.SelectedDate),"DD/MM/YYYY") ) }, // show only dates Monday to Friday and exclude holidays CountIf( varDateRange, And( Weekday(Value,StartOfWeek.Sunday) in [2, 3, 4, 5, 6], Not(Value in Holidays.Date1) ) ) )

Hope this will help you,
Best Regards,
Tina