Skip to content
Working Days
Last edited 172 days ago by Lukas Pavelka.
Formula Code
WorkDays(StartDate:DateTime,EndDate:DateTime):Number=Sum(AddColumns(ForAll(Sequence(DateDiff(StartDate,EndDate,TimeUnit.Days)+1),StartDate+Value),IsWeekday,Weekday(Value) in [2,3,4,5,6]),IsWeekday);
Eye on Detail
Mostly, we play with Date functions in Power Apps. In this function we input our start and end day, where the output is a number of calculated working days without weekends. For example, it is great for submitting absence to see how many working days you will be off.
Demo
Output
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.