Column Formula to Highlight Rows from the Current Week

I am trying to create a conditional format to highlight rows from the current week (starting Monday), based off the Start Date column.

I have found a formula here but it wont let me convert to a Column Formula:

=IF(WEEKNUMBER([Start Date]1) = WEEKNUMBER(TODAY()), 1)

I added the conditional formatting but it is not working.

Additionally, sometimes we have a row without a date yet. Is there a way to add to the formula to ignore empty cells so that it doesnt give off the INVALID code?

Find more posts tagged with

Accepted answers

All comments

Mike TV

@HenryWong

You can't make it a column formula because you're specifying an exact cell instead of @row, etc. Your formula should be (and then you can make it a column formula):

=IF(WEEKNUMBER([Start Date]@row) = WEEKNUMBER(TODAY()), 1)

Please show your conditional formatting setup.

For the error when blank problem:

=IFERROR(IF(WEEKNUMBER([Start Date]@row) = WEEKNUMBER(TODAY()), 1), "")

HenryWong

Thank you! That formula worked! Conditional formatting still doesn't work..however.

HenryWong

Duplicate

Mike TV

@HenryWong

On the "this format", change the fill background color to yellow using this icon:

You've set the task bar color to yellow but that only shows on card view or calendar view or something like that, I forget.

HenryWong

@Mike TV Thank you so much, Michael!

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.