Get Current Business working day number of the month(Excluding sat,sun and other mandate offs(attached excel))

  1. Based on system date,day - i need to get the current business working day number (excluding Saturdays,Sundays and any mandatory offs based on the particular region - Attached excel file for reference)

  2. Excluding all the non-working days(sat,sun and mandatory holidays) - The current business working day number should be “11”

I have searched online but could not get any related answers.

It would be really helpful if anyone of you help me.

ListOfHolidays.xlsx (8.9 KB)

1 Like

Hi HarshitRao,

Please check the attached xaml fileGetBusinessDaysCount.xaml (9.8 KB)

let me know if you have any queries

Thanks,
Stay safe