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.
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.
-
Both columns are date properties.
-
Awesome. Thanks for the help.
-
Happy to help. 👍️
-
@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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!