Help with counting # of items that have start dates between X and X date


I can't seem to figure out how to get a count of all items with a start date between 5/4/20 and 5/8/20. This will be used as part of a COUNTIFS formula if that helps, I was able to get the first two criteria in but can't figure out the dates.

The start date reference column is in another sheet and each cell only includes a single date.

Any help is greatly appreciated.

Thank you!


  • Here is the formula I currently have which is not working if this helps...

    =COUNTIFS({Evergreen Hiring Surge Range 3}, <=DATE(2020, 4, 27), {Evergreen Hiring Surge Range 3}, >=DATE(2020, 5, 1))

  • Jon Baier
    Jon Baier ✭✭✭✭

    I created a date column on one sheet, and referenced it on another using your 'Evergreen Hiring Surge Range 3" as the name of the reference. I got it to work by adding another set of () in the criterion of each date evaluation.

    =COUNTIFS({Evergreen Hiring Surge Range 3}, <=(DATE(2020, 5, 30)), {Evergreen Hiring Surge Range 3}, >=(DATE(2020, 5, 1)))

    See if that works for you.

  • It worked! Thank you for your help, I really appreciate it. This forum is wonderful 😀

  • Jon Baier
    Jon Baier ✭✭✭✭

    You're welcome. Sometimes the simple things will drive you nuts with Smartsheet formulas. 😃

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!