Check Date is a Saturday or Sunday

(0) Share

Report

Posted on by Sam70

256

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:

General Comment

All responses (2)

Answers (1)

Verified answer

Sam70 256 on at

Like (0)

Report

Check Date is a Saturday or Sunday

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.
Suggested answer

MS.Ragavendar 1,126 on at

Like (0)

Report

Check Date is a Saturday or Sunday

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.