COUNTIFS Formula

I'm having a hard time figuring out the formula to use if I have a column of dates and I want to count how many cells fall between a date range.

I have tried the following formula and the results came back with 0, however I know there there are 7 cells in the column that fall under the date range.

=COUNTIFS(Date2:Date73, >=DATE(2019, 2, 1), Date2:Date73, <=DATE(2019, 2, 28))

HELP!

Find more posts tagged with

Project Management

Comments

Nic Larsen

Try this:

=COUNTIFS(Date:Date, AND(@cell >= DATE(2019, 2, 1), (@cell <= DATE(2019, 2, 28))))

**Edit, I updated it to remove the OR for an AND. Works for me now. **

aballard56561

What would the @cell be?

Nic Larsen

You don't need to change that, its just a function of the formula. It takes your overall range and goes cell by cell to see if it meets the criteria of between 2/1 to 2/28.

Mike Wilday

For more information on @cell see: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

Paul Newcome

Your original formula should work if you add the @cell before each of your criteria though. The syntax is correct otherwise.

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…