Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Week Of Forumla

Topic Labels: Dates & Timezones Formulas
253 1
cancel
Showing results for 
Search instead for 
Did you mean: 
katys
4 - Data Explorer
4 - Data Explorer

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
Alexey_Gusev
13 - Mars
13 - Mars

Hi.

DATEADD(DateField,1-WEEKDAY(DateField),'days')