Automatic update to count values within a specific month


Hi, I currently use a countifs formula to count  the number of met criteria within a given  month. Data is entered monthly through a form.  What formula can I use to automatically update the month automatically?   The below formula works, but I have to manually enter the first and last day of the month in its respective column.

=COUNTIFS({Date}, >=[1st Month]1, {Date}, <=[Last Month]1, {Time Out Audit Range 3}, "met")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!