Countifs Question

I have a sheet that has 2 date columns, 1 is the date we scheduled an activity, the 2nd column is the date that it was actually completed. I need to count the number of times these dates are the same broken out by month.

COUNTIFS([Date1]:[Date1], [Date2]:[Date2], [Date1]:[Date1], >=DATE(2023, 1, 1), [Date1]:[Date1], <=DATE(2023, 1, 31))

I need to write a report that shows every month with this number:

Month comp. on original date comp. on different date

Jan 100 0

Feb 50 23

Mar

Apr

etc.

I'm using that formula above, but it's not working

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!