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.
-
Hi there,
I'm looking for something similar and am stuck on my formula. We have a class ("LCST") that happens throughout the work week (M-F); and we pull a report every Friday with the range of the prior Friday through current week's Thursday. For example, on today 11/08/24, we would run the report for (last Friday) 11/1 - (yesterday, Thursday) 11/7.
So far, I have the formula as:
=IF(OR(Class@row = "DX Traditions", Class@row = "LMTR"), [Start Date]@row + 1, IF(Class@row = "LCST", ([Start Date]@row + 6 - WEEKDAY([Start Date]@row))))
This formula works okay as long as the start date is not a Friday. See the below highlighted in yellow — a Friday date remains the same. Can anyone help incorporate what to do if the start date IS a Friday? How can I get the Aftercare column to reflect the following Friday?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!