Calculate Week Between the Selected Date

(0) Share

Report

Posted on by omi18

640

Hello All,

Is there any way we can calculate the total number of weeks between the selected date?

Case: I have two Date pickers where users can select the start and end date. And I'm trying to display the total number of Weeks between the selected Dates. The week starts on Monday and ends on Sunday.

i.e. Start Date 01/31/2022 End Date 05/08/2022 Total Weeks 14.

Any Suggestions?

Thanks,

Omi

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!
See code below, two date pickers are datepicker1 & datepicker2

check before implementing what weekday() provides for Sunday and Saturday in your environment. In mine weeks run Sunday - Saturday and I believe that's default. So formula in my example uses that. If yours is different just change the 1 & 7 in formula to your sat&sun values

If( Or(Weekday(DatePicker1.SelectedDate)=7,Weekday(DatePicker1.SelectedDate)=1), Sum(1, CountIf( ForAll( Sequence( DateDiff( DatePicker1.SelectedDate, DatePicker2.SelectedDate, Days ) ), If( Or( Weekday(DateAdd(DatePicker1.SelectedDate,Value,Days))=1, Weekday(DateAdd(DatePicker1.SelectedDate,Value,Days))=7 ), {Value:1})),Value=1) ), CountIf( ForAll( Sequence( DateDiff( DatePicker1.SelectedDate, DatePicker2.SelectedDate, Days ) ), If( Or( Weekday(DateAdd(DatePicker1.SelectedDate,Value,Days))=1, Weekday(DateAdd(DatePicker1.SelectedDate,Value,Days))=7 ), {Value:1})),Value=1) )

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

I misread this as weekend dates haha, one second the weeks I actually already have, and will post here

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!
Ok so here it is for calculating NUMBER of weeks contained in a range, it counts any portion of a week Sunday-Saturday. It also calculates properly if that date range stretches from 1 year into another.

If( Year(DatePicker1)=Year(DatePicker2), Sum( WeekNum(DatePicker2.SelectedDate)- WeekNum(DatePicker1.SelectedDate))+ 1, Sum( WeekNum(DateValue(Concatenate(12,"/",31,"/",Year(DatePicker1))))- WeekNum(DatePicker1.SelectedDate)+ WeekNum(DatePicker2.SelectedDate)+ 1 ) )

Was this reply helpful? Yes No
omi18 640 on at

Like (0)

Report
Copy link

Link copied!

Hi @TheRobRush ,

Thanks for the message. With the same formula, I'm getting 15. But I think it is supposed to be 14.

Thanks,
Omi

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!

If counting any portion of this date range it would be 15, because the final date, May 1st, falls on a sunday which is day 1 of a new week.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

Work Weeks in PowerApps by default run sun-saturday (theres a way to change the week start date in powerapps if you run say mond-sun instead)

Was this reply helpful? Yes No
timl 37,160 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

That's a great solution @TheRobRush!

The Weekday/Weeknum functions accept a second argument to define the start of week. If you pass StartOfWeek.Monday, I guess that would cover the final piece of this?

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!

Great Timl, thank you for that. I never change mine so wasn't 100% sure of the modifier syntax

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
@omi18 that looks like

WeekNum(DatePicker2.SelectedDate,StartOfWeek.Monday)

Was this reply helpful? Yes No
omi18 640 on at

Like (0)

Report
Copy link

Link copied!

No Problem, Thanks for the solution. 🍻

Was this reply helpful? Yes No