finding Weekdays in month

[PNC97]

Trying to find out Saturday and Sunday in a month. If yes, to have a new column with 1 as yes and 0 as no.

Attached sample data with expected output

[atcodedog05 · Accepted solution]

Hi @PNC97 

Formula would be like this

IF DateTimeFormat([Date],"%a") in ("sat","sun") THEN 1 
ELSE 0 ENDIF

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @PNC97 

Cheers and have a nice day!