How to count the number of events in a given month regardless of year.

Omars
Omars
edited 07/12/22 in Formulas and Functions

I'm drawing data into a calc sheet from another sheet and I want to determine the number of events we've had in February (for example) over the course of several years. So I'm trying to do a countif formula for the dates but can't seem to find a workable equation. TIA for your help.

Answers

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭

    Assuming that the event date is in the column named, Date_Event, your count of events for the month of February would be...

    = COUNTIF( Date_Event:Date_Event, MONTH(@cell) = "2")

    For March, it would be...

    = COUNTIF( Date_Event:Date_Event, MONTH(@cell) = "3")

    ..and so on.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!