Countifs projects starting or ending this week in sheet Summary formaulas

Hi all,

I need help on a formula to gather how many projects are due to start this week. I have this so far, but it returns 0, but one date range is within the parameters.

=COUNTIFS([Target Start Date]:[Target Start Date], WEEKNUMBER(TODAY()))

I also need to count on the [Target End date] on how many are due for completion this week.

All this has to be captured in sheet Summary formulas.

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

Kelly Moore

Hi @David Clunie

Try this

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

The piece missing from the formula above was the conversion of the [Target Start Date] into a WeekNumber so the formula could perform the comparison to WeekNumber (Today()). This is now accomplished using WEEKNUMBER(@cell).

I added the IFERROR to take care of any blanks or non-date entries in your date columns

cheers,

Kelly

All comments

Kelly Moore

Hi @David Clunie

Try this

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

I added the IFERROR to take care of any blanks or non-date entries in your date columns

cheers,

Kelly

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.