How to count how many interviews in the current week?

Louis.Smith

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

@Louis.Smith,

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

@Louis.Smith,

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

https://community.smartsheet.com/discussion/comment/381528#Comment_381528

Thank you, this does work with including today.

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

Ray Lindstrom

@Louis.Smith,

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

https://community.smartsheet.com/discussion/comment/381601#Comment_381601

yes, for the current week