Need the Date of the beginning of the week.

how do I create a Week of Date based on dates during the week? For example the Delivery date of 10/21 I want populate the Week Delivery Date with the week number Date. Do I need to create and additional week number column or is there a formula I can use?
Best Answers
-
Make sure that the column you are putting the formula in is set to a date type column.
-
yep that was it! thank you.
Answers
-
-
-
Ok. And what happens for weekends? Does Saturday and Sunday go to the previous Monday or the following Monday, or are they split so that one goes one way and the other goes the other way?
-
Saturday and Sunday go to the previous Monday
-
Give this a try:
=[Date Column Name]@row + (2 - WEEKDAY([Date Column Name]@row)) - IF(WEEKDAY([Date Column Name]@row) = 1, 7, 0)
-
I'm getting an error
-
Make sure that the column you are putting the formula in is set to a date type column.
-
yep that was it! thank you.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 442 Global Discussions
- 154 Industry Talk
- 503 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!