How to count how many interviews in the current week?

Louis.Smith · 06/21/23

I am currently trying to track how many interviews are scheduled in the current week per fleet type?

The formula I have is counting 7 days from today but isn't including the current day.

=COUNTIFS([Interview Date]:[Interview Date], @cell = TODAY(7), [Interview Date]:[Interview Date], @cell > TODAY(), Fleet:Fleet, "A220")

Ray Lindstrom · 06/21/23

Awesome, glad it worked! Please remember to click the Answer button if you don't mind.

Re: "Is there a way to create a formula for the current?" - By this do you mean for the current week?

Ray Lindstrom · 06/21/23

In your second Today(), try Today(-1)

Basically you're excluding today by saying "greater than today". What I'm suggesting is saying "greater than yesterday" which includes today.

Hope this helps!

BRgds,

-Ray

Louis.Smith · 06/21/23

Thank you, this does work with including today.

Is there a way to create a formula for the current?

Ray Lindstrom · 06/21/23

Awesome, glad it worked! Please remember to click the Answer button if you don't mind.

Re: "Is there a way to create a formula for the current?" - By this do you mean for the current week?

Louis.Smith · 06/21/23

yes, for the current week

Best Answer