SOLVED
finding Weekdays in month
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PNC97
8 - Asteroid
‎08-13-2021
06:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
2 REPLIES 2
22 - Nova
‎08-13-2021
06:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @PNC97
Formula would be like this
IF DateTimeFormat([Date],"%a") in ("sat","sun") THEN 1
ELSE 0 ENDIF
Workflow:
Hope this helps : )
22 - Nova
‎08-13-2021
06:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @PNC97
Cheers and have a nice day!
