Current week formual

Hi all,

I am trying to count the number of planned activities for the current week using Planned Start Date column. I have the following formula, but it does not work. Does any one have any idea.

=COUNTIFS([Planned Start Date]:[Planned Start Date], >= TODAY() - WEEKDAY(TODAY(), 2) + 1, [Planned Start Date]:[Planned Start Date], <= TODAY() - WEEKDAY(TODAY(), 2) + 7)

Find more posts tagged with

Accepted answers

All comments

Melissa Yamada

Hello @SASGE

Try this:

=COUNTIFS([Planned Start Date]:[Planned Start Date], WEEKNUMBER(TODAY()) = IFERROR(WEEKNUMBER(@cell ), 0))

SASGE

Hello Melissa,

Thank you for the help. The formula seems to be working with one error, it returns on extra activity. I have 2 activities planned for the week, but it returns 3. I have tested with different columns and different scenarios, but it always returns one more (if I have 5 activates, it returns 6).

I am not sure what is going on.

Regards

Sayed

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.