web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Get the date of this w...

Power Apps

Answered

Get the date of this weeks monday and friday

(0) Share

Report

Report

Posted on by Field

339

Is there a way to get the dates of this week monday and friday?

I used Today() + 7 - Weekday(Today(), MondayZero)

But it will either give me next week day, or if i remove the +7, it will give me last week. Never the current one.

Any help?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(12)

Report
Copy link

Link copied!
@Field

My solution assumes your week starts on Monday.

Here's how you get the current week's Monday

DateAdd(Today(),1-Weekday(Today(),StartOfWeek.Monday),Days)

Here's how you get the current week's Friday

DateAdd(Today(),1-Weekday(Today(),StartOfWeek.Monday)+4,Days)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
DianaLucia 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello! It worked, now it stopped working. Power Automate sends a message saying it is not valid.

Was this reply helpful? Yes No
Mcgallian 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Just responding to this as I just had to build out a similar formula. I used:
DateAdd(
Today(),
-Mod(Weekday(Today()) - 2, 7)
)
The -2 is to account for what day your calendar starts on, so check the date output and adjust as needed

Was this reply helpful? Yes No
ArtieLeech 42 on at

Like
a
(0)

Report
Copy link

Link copied!
I had to tweak my version slightly, to add the TimeUnit prefix, like this:

DateAdd(Today(), 1-Weekday(Today(), StartOfWeek.Monday), TimeUnit.Days)

Was this reply helpful? Yes No

Join the conversation