I am building an app to register employee's trips.
I have 2 date pickers: trip start day and trip end day, simple.
The complication is they asked me to count how many work days that employee has lost. But it has to substract weekends and national holidays. For that, I have an Excel table with all the dates I want to substract.
The problem is when I import that Excel to PowerApps, it adds some values. For example 10/10/2020 -> 10/10/2020 2:00.
I imagine it has something to do with time zones or something, I tried changing the format from Excel but nothing.
My idea is to make a Collection with ALL the days between the start day and the end day. Then another Collection with all the weekends and holidays, and substract the common values.
I've been working on it for hours and I just don't see it.