Helper column to differentiate current week from following week

Hello,

I have determined a way to identify the day of the week via a helper column formula with additional helper columns for the current week. What I want is a way to differentiate the current week from the following/next week. This is strictly Monday - Friday Business days. I will post below my current situation. Please let me know what I can do to separate these from each other. Thank you all!

Day of the week Formula: =IF(WEEKDAY([Start Date（訪問開始日）]@row) = 2, "Monday", IF(WEEKDAY([Start Date（訪問開始日）]@row) = 3, "Tuesday", IF(WEEKDAY([Start Date（訪問開始日）]@row) = 4, "Wednesday", IF(WEEKDAY([Start Date（訪問開始日）]@row) = 5, "Thursday", IF(WEEKDAY([Start Date（訪問開始日）]@row) = 6, "Friday")))))

Current Week: =IF(WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY()), 1)

[FORMULA IN QUESTION]

Following Week: =IF(OR(WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY()) + 1), 1)

Find more posts tagged with

Formulas

Accepted answers

Brian_Richardson

I think you basically have it. To see if it's next week try:

=IF(WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY(7)), true)

Or do a combined formula in one column that indicates "This Week" or "Next Week" or "Other"

=IF(WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY(7)), "Next Week", IF (WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY()), "This Week", "Other Week"))

All comments

Brian_Richardson

I think you basically have it. To see if it's next week try:

=IF(WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY(7)), true)

Or do a combined formula in one column that indicates "This Week" or "Next Week" or "Other"

=IF(WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY(7)), "Next Week", IF (WEEKNUMBER([Start Date（訪問開始日）]@row) = WEEKNUMBER(TODAY()), "This Week", "Other Week"))

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.