web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages Count number of workin...

Power Pages

Answered

Count number of working days between two days

(0) Share

Report

Report

Posted on by HerrM

11

Hi,

I have a table that contains a start date and an end date. I would like to evaluate, how many working days are between those two dates, e.g.:

-start date: monday the 22th

-end date: monday the 29th

-write "6" into a separate table column

By now I could not find a way to do this.

Thanks a lot in advance!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Lucas001 2,555 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I guess you want something like that:
You can just create a column with the type formula.
Formula in that Case would be DateDiff(StartDate,EndDate)

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up. Thanks.

Was this reply helpful? Yes No
Verified answer

HerrM 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @Lucas001 ,

Thanks a lot for your reply!

This solution also counts the weekend (Saturday and Sunday) that I want to exclude in my calculation.
e.g.: if you put Friday the 19th as start date and Monday the 22nd I want the Output "2", because I only want Friday and Monday to be counted, not Saturday and Sunday.

I found a sort of a workaround: I only need this value for visualization, so I used the NETWORKDAYS - function in Power BI and then included Power BI into my power pages website.

But I would prefer a solution, where I could do this directly in the tables 🙂

Best regards

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

You're Invited to Keeping It Real with the Power Platform

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

oliver.rodrigues 36 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans