How to get the month from a date in google sheets

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

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

Tags