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:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!