Calculating Month from Date Column

Andrea Mayer
Andrea Mayer ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


I am looking for help with the formula below. I am referencing another sheet and trying to calculate the number of rows that fall within January in the 'Milestone Due Date' column. The dates in the 'Milestone Due Date' column displayed in the following format: mm/dd/yy.

=COUNTIFS({Project}, [Primary Column]@row, {Milestone Due Date}, =MONTH(1))

Appreciate any help anyone can provide.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!