Need help with a date formula to always return a Friday date.

Jose G.

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.

Find more posts tagged with

Accepted answers

Carson Penticuff

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

Paul Newcome

Column names containing a space, number, and/or special character need to be wrapped in [square brackets] when referenced in a formula.

All comments

MichaelTCA

Hello @Jose G.

What are the column properties for both Date and Customer Date Needed?

Carson Penticuff

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

Paul Newcome

Column names containing a space, number, and/or special character need to be wrapped in [square brackets] when referenced in a formula.

Jose G.

https://community.smartsheet.com/discussion/comment/386143#Comment_386143

Both columns are date properties.

Jose G.

Awesome. Thanks for the help.

Paul Newcome

Happy to help. 👍️

MichaelTCA

@Jose G. If the brackets fixed your issue, than great!

The NETDAYS() function works as well. Both columns would have to be dates though.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.