Online Tutorial for Data Analysis and Automation
The DATE, DAY, and MONTH Functions in Google Sheets are incredibly useful when you need to extract specific pieces of information from a full date. For instance, you might need to find out the exact day of the month or pull just the month or year from a given date. These functions make it quick […]
Use the TEXT and MONTH functions in Google Sheets to get the day name and month number from any date. Worked example with 17 dates, format codes, counts, quarters, weekend flags and common fixes.
Combine FILTER and MONTH in Google Sheets to return every row from a chosen month, with a worked example, month-and-year filtering, monthly totals and fixes for common errors.