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

Louis.Smith · 06/13/23

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 · 06/13/23

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

Louis.Smith · 06/13/23

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 · 06/13/23

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

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

Answers

Help Article Resources

Categories