How to get the month from a date in google sheets


Have a bunch of rows that you want to group by month, but you only have the individual dates?


Use =MONTH(date) to convert those dates into their month

formula-month

Common Use Cases


  • Preparing your data for a month to month time series graph
  • Getting a count of pageviews per month
  • Summing up your revenue by month