Wrong counting of days

(0) Share

Report

Posted on by Filistyn

290

Hey, I have this code

 If(
 Weekday(
 StartDate.SelectedDate;
 StartOfWeek.Monday
 ) = 6 Or Weekday(
 StartDate.SelectedDate;
 StartOfWeek.Monday
 ) = 7 Or Weekday(
 EndDate.SelectedDate;
 StartOfWeek.Monday
 ) = 6 Or Weekday(
 EndDate.SelectedDate;
 StartOfWeek.Monday
 ) = 7;
 "You can't choose weekend";
 EndDate.SelectedDate < StartDate.SelectedDate;
 "Wrong order of days";
 (RoundDown(
 DateDiff(
 StartDate.SelectedDate;
 EndDate.SelectedDate;
 Days
 ) / 7;
 0
 ) * 5 + Mod(
 5 + Weekday(EndDate.SelectedDate) - Weekday(StartDate.SelectedDate);
 5
 ) + 1 - If(
 LookUp(
 Employees;
 NameOfEmployee = User().Email
 ).Title = "NOARKCZ";
 CountIf(
 Holidays;
 DateOfHoliday >= StartDate.SelectedDate;
 DateOfHoliday <= EndDate.SelectedDate
 );

and im working with this:

basically you choose Vacation between two dates and it will calculate how many days are between the dates. "Holidays" is a Sharepoint list, where I've listed all the holidays. It also excludes weekends. It works perfectly, but over Christmas it doesn't seem to work.

Any idea why?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Filistyn 290 on at

Like
a
(0)

Report
Copy link

Link copied!

I think that the problem seems to be, that if there is a difference, between two dates and the day, where the holidays are, are also weekend, it will subtract it as a 2 days, because the code thinks, that the day is weekend and also holiday.

Was this reply helpful? Yes No
Verified answer

v-JessicaG-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Filistyn ,

You could exclude holidays and weekend overlapping days from your count. I have test for your reference, please try the following workaround:

Formula:

RoundDown( DateDiff(StartDate.SelectedDate, EndDate.SelectedDate, Days) / 7, 0) * 5 + Mod(5 + Weekday(EndDate.SelectedDate) - Weekday(StartDate.SelectedDate), 5) + CountIf( Holidays, DateOfHoliday >= StartDate.SelectedDate, DateOfHoliday <= EndDate.SelectedDate, ( Weekday(DateOfHoliday,Monday)=6 || Weekday(DateOfHoliday,Monday)=7) )

Best Regards,

Jessica Gu

Was this reply helpful? Yes No