Summarize Data by Quarter in Google Sheets
Summarize your Google Sheets data by quarter using three methods: functions, pivot tables, and query.
Tutorials
Show the Day of the Week as Text – Google Sheets
This tutorial shows you two ways to display your dates as the day of the week in your spreadsheet. The default is to show the month, day, and year together. Therefore, you will have to make a few changes depending on the type of output you want. Grab a copy of this template to follow … Read more
How to Use Dates and Times in Google Sheets Formulas
Dates are notoriously finicky to use in spreadsheets. You can’t type them into a formula and expect it to work. However, there are a few different ways to use them in formulas. Once you know how, using dates is much easier. Method 1 – Surround Dates and Times with Quotes For the first example, dates … Read more
Date Functions – Using Dates and Times in Google Sheets
Learn the nuances of working with dates and times in Google Sheets.
How dates and times work in Google Sheets
Learn how dates and times work in Google Sheets. They are numbers, but they come with many nuances you need to understand.