Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 12:05 PM - edited ‎Nov 18, 2024 12:08 PM
How do I write a formula to populate anything that is created in that week, it will add the Monday date of that week.
For Example:
I have records for 10/7, 10/8, 10/10. I need the Starting Week of to be: 10/7 for all Dates.
Then I need records for 10/14, 10/15, 10/16, etc. To be starting week of 10/14.
I also have the: WEEKNUM({Created Date}) formula, so if there is an easier way to turn that week number into the starting date of the week, I can use that as well.
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 20, 2024 01:37 AM
Hi.
DATEADD(DateField,1-WEEKDAY(DateField),'days')
