Count Dates

Corporate Corporate

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!!!!

Heather Duff

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

Corporate Corporate

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

Matt Travis

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)