Google Sheets Query Group Date Field by Month

This video illustrates how to create a Query in Google Sheets where the output groups a Date Field by "Month." So in this example we have a dataset of loan detail information. The last column contains the loan disbursement date. The objective in this video is to create a query output that summarizes (groups by) this data by "Disbursement Month." Therefore we need to convert the date field to a "month only" field. This is achieved by splitting our dataset into two seperate arrays. The first array contains our other data fields and the second array contains our Disbursement Date Field. This second array field is nested within the "End Of Month" Function (and also the "Array_Formula") to convert the date values in this column to Month Only.

Learn more about Google Sheets Functions with this Book at Amazon.

Buy the complete Google Workspace User Guide at Amazon:

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links