Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using formula - Pick first day of the week
ysuzuki
✭
For example, today is 11/15, and first of the day (Monday) of this week is 11/13. How can I pick up 11/13?
Thanks for your advice!
Tags:
Comments
-
Hello ysuzuki!
To write a formula that takes a date and then displays date of the Monday of that week, you can take advantage of the WEEKDAY() function which returns a number representing the day of the week, 1-7, where Sunday equals 1.
If you have a sheet where the date is in a column called Date and the formula is in a column called Monday, use the following formula:
=Date1 - (WEEKDAY(Date1) - 2)
For more information, see https://help.smartsheet.com/functions
Thanks!
Schiff
Smartsheet Support -
Thank you Schiff! It worked like a charm!
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives