Check Date is a Saturday or Sunday

(0) Share

Report

Posted on by Sam70

271

Hi,

I need a formula in PowerApps, where it will check whether 20th of the current month is Saturday or Sunday. If 20th is Saturday, then need to populate a variable as 22 or if 20th is a Sunday, then the value of the variable will be 21

Regards

Categories:

Power Query

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

MS.Ragavendar 4,975 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

With(DateCheck20, Date(Year(Today()),Month(Today(),20),

If(Weekday(DateCheck20)=7,Date(Year(DateCheck20),Month(DateCheck20),22,

Weekday(DateCheck20)=`,Date(Year(DateCheck20),Month(DateCheck20),21,DateCheck20)

)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

Was this reply helpful? Yes No
Verified answer

Sam70 271 on at

Like (0)

Report

Hi,

Had to edit the formula as below.

With({DateCheck20: Date(Year(Today()),Month(Today()),20)},

If(Weekday(DateCheck20)=7,Date(Year(DateCheck20),Month(DateCheck20),22),

Weekday(DateCheck20)=1,Date(Year(DateCheck20),Month(DateCheck20),21),DateCheck20))

Now it is working. Thanks.

Was this reply helpful? Yes No