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
Solved! Go to Solution.
Hi @PNC97
Formula would be like this
IF DateTimeFormat([Date],"%a") in ("sat","sun") THEN 1
ELSE 0 ENDIF
Workflow:
Hope this helps : )
Happy to help : ) @PNC97
Cheers and have a nice day!