# Count Dates

Options

Trying to Cross Reference and count dates in a column that are due with = 14 days, = 30 days, = 60 days out. Capture projects due within these date ranges. Thank you!!!!

• ✭✭✭✭✭✭
Options

Hi! Try this, assuming that {date} is the named range for the due date column in your source sheet.

=countif({date}, @cell>=TODAY(-14))

In the place of 14, you can enter 30 and 60 for their respective cells.

Hope this helps!

Best,

Heather

• Options

Well that did work, =COUNTIF({Projects 2021 Due Date}, @cell >= TODAY(+14), IF({Projects EVP} = "true")) ....but I needed to add another criteria and now #incorrect Argument Set :<

I've tried =countif(and( .... countifs, I have literally been trying to get this formula to work all morning.

Thank you, thoughts on this one

• Options

Hi,

For multiple criteria you will need to use COUNTIFS but also you don't need to make another IF statement within the formula.

So: =COUNTIFS({Projects 2021 Due Date},@cell >= TODAY(+14), {Projects EVP},="true")

The general layout is =COUNTIFS({InfoRange1},Criteria1, {InfoRange2},Criteria2)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!