Count Dates

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



  • 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

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