Formula to count how many interviews are within the last 7 days and are this week?

I am try to find the right formula to count how many interviews are within the last 7 days but also count anything happening in the next 7 days.

The formula I used for the last 7 days is:

=COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(), [Interview Date]:[Interview Date], @cell > TODAY(-7))

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you wanting them combined into the same count or two separate counts?

Louis.Smith

https://community.smartsheet.com/discussion/comment/380325#Comment_380325

can you give me the formula for both so that I can see the metrics that we get to determine.

Paul Newcome

It is just a matter of adjusting the numbers inside of each TODAY function. SO combined last seven days and next seven days would be less than TODAY(7) and greater than TODAY(-7). Similar logic would be used for just the next seven days where you would use greater then TODAY() and less than TODAY(7).

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.