Month Function

cjleon

Hello,

I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. 

e.g.

| January |  45  |

---------------------

| February|  20 |

However, I am finding trouble actually calculating the amount based off of the creation date. I figured a solution would be to use creation date to extract the month then a SUMIF/COUNTIF to count the amount within a month. Unfortunately, it has only said invalid data type. 

Thanks in advance!

David Hersher

Hello,

I used =MONTH to pull the month # from a date column into its own column called MONTH.  Then, this seemed to work:

=COUNTIF(Month:Month, =1)

=COUNTIF(Month:Month, =2), etc.

Hope that helps.

Dave

 

 

cjleon

Thanks for the response! 

It worked out perfectly.