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

Options

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

Tags:

• ✭✭✭✭✭✭
Options

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

• Options

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

• ✭✭✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!