How to count number of entries that fall between two dates

Options

Hi!

I have a sheet that has a date column to enter the initial date of contact. I want to count how many of those entries fall between 2 dates (by month) i.e. I want to know how many of the entries have a date between 1/1/22 and 1/31/22. This is my formula but it's not calculating correctly as I know I have 2 entries with Jan 2022 dates. What have I missed here?


=COUNTIFS({Special Projects Division Master Initial Contact D}, <=(DATE(2022, 1, 1)), {Special Projects Division Master Initial Contact D}, >=(DATE(2022, 1, 31)))


Thanks for the help! As always!!

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!