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

Louis.Smith

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))

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).