'Calculate number of working days in ADF pipeline
I have tow columns named start_date and end_date, on the basis of this how can I calculate Number of Working Days(Mon-Fri) in my ADF pipeline.
E.g: start_date - 25/01/2022 end_date - 04/02/2022
Working days = 9
Solution 1:[1]
You can use azure function to calculate weekdays.
Sample Code for Body –
{
“total_days”:365,
“working_days”:253,
“holidays_removed”:9,
“start_date”:”yyyy-mm-dd”,
“end_date”:” yyyy-mm-dd”
}
Refer this article by RYAN MACLEAN for more information
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | AbhishekKhandave-MT |