SOLVED
Day+7-Weekday
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
Kinetic_analytics
11 - Bolide
‎12-21-2021
05:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello:
How can I transform the following Excel formula into alteryx?
=A2+7-WEEKDAY(A2)
Thanks
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
EmilyCR
Alteryx Alumni (Retired)
‎12-21-2021
10:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can re-create this particular formula using a series of DateTime functions within the formula too. I have uploaded an example of how you would achieve this.
Hope this helps!
Emily
‎12-22-2021
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. 🙂
