Need help with a date formula to always return a Friday date.
I see there is a standard formula and you just need to change the last number depending on the day of the week.
Date@row - WEEKDAY(Date@row) + 2
The "+ 2" can be modified to pick a different day of the week. 1 = Sunday, 3 = Tuesday, etc.
Here is the formula on my sheet but is shows #unparseable.
=Customer Date Needed@row - WEEKDAY(Customer Dated Needed@row) + 6
Thanks.
Best Answers
-
If your column name contains spaces, you will need to enclose it in square brackets.
=[Customer Date Needed]@row - WEEKDAY([Customer Dated Needed]@row) + 6
-
Column names containing a space, number, and/or special character need to be wrapped in [square brackets] when referenced in a formula.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Hello @Jose G.
What are the column properties for both Date and Customer Date Needed?
-
If your column name contains spaces, you will need to enclose it in square brackets.
=[Customer Date Needed]@row - WEEKDAY([Customer Dated Needed]@row) + 6
-
Column names containing a space, number, and/or special character need to be wrapped in [square brackets] when referenced in a formula.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Both columns are date properties.
-
Awesome. Thanks for the help.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Jose G. If the brackets fixed your issue, than great!
The NETDAYS() function works as well. Both columns would have to be dates though.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!