"Week Starting" date from created date
Hello Formula Gurus!
Do any of you have a formula that will return the "week starting" date based on a created date? So evaluate the created date of a row and bring back the date of Monday that week.
Thanks much,
Andrea
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
Best Answers
-
=IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - (WEEKDAY(Date@row) - 2))
-
Here's what I got to work:
=Created@row + (2 - WEEKDAY(Created@row))
Where "Created" is the Created Date Column.
Let me know if you need any further assistance!
-Jon Mark
Answers
-
=IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - (WEEKDAY(Date@row) - 2))
-
Here's what I got to work:
=Created@row + (2 - WEEKDAY(Created@row))
Where "Created" is the Created Date Column.
Let me know if you need any further assistance!
-Jon Mark
-
@Leibel Shuchat Beautiful! Works exactly as I wanted. Thanks much!
Andrea
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
-
@Jon Mark H that works too! 😊
Andrea Zenner
Program Manager | Infrastructure & Operations
Apogee Enterprises
EAP | Mobilizer | Core Product Certified | Superstar
azenner@apog.com
-
Glad to help!
-
@Leibel Shuchat thanks for this!!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!