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

Nichole Pyle

Hello,

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!

Nichole Pyle

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

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.

Nichole Pyle

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

Jon Baier

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