Count if dates are within the next 7 days

Hello,

I'm trying to use the COUNTIFS function to search a reference column full of dates to count how many are within the next 7 days. For the criteria portion of the formula, I've tried using, "<TODAY(7)", "<TODAY() + 7", but they are not providing me with the correct (if any) result. I would like to avoid having to create a workaround by adding a new column to identify if the aforementioned criteria is true, then counting it that way.

What am I missing? HELP!

Find more posts tagged with

Formulas

Community Platform

Comments

Shaine Greenwood

Hello,

If you're only using one criteria, you'll want to use COUNTIF instead of COUNTIFS.

For example:

=COUNTIF(Start:Start, <=TODAY(7))

The above function will count all of the dates if the start date is less than or equal to the current date + 7 days. You'll want to change the Start:Start to the range of your own column in your sheet.

If you're still experiencing issues, let me know what formula you're using and the errors or behavior you're expecting.

Tynisha

Perfect, thank you Shaine!

Rafsun Royal

Hi Shaine,

I am using this

=COUNTIF([Production Move Date]:[Production Move Date], <=TODAY(7))

to get the count for how many will be in production in next 7 days but getting count of 0 though I have 3 that has production date in tomorrow and day after tomorrow.

Appreciate your help!

Thanks,

Rafsun

Andrée Starå

Hi Rafsun,

Did you get it working because what I can see it should?

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…