Google Sheets Tutorials · Better Sheets

Ian Asks: How to sort dates by year/month (can't do with filter)

In Excel you actually have these options of sorting by year, by month, by date. But let's do it in Google Sheets.

Find the Start date of the Current and End date of the Current Month

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.

EOMONTH() TODAY()

How Many Days Between Two Dates?

Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.

Intermediate

DATE() DATEDIF()

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!

Beginner

FILTER() IF()

How To Filter Dates (They Are Numbers Too!)

Dates are numbers so you can filter them with greater than and less than.

Beginner

FILTER() IFERROR()

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.

Beginner

COUNT() IF() INDEX()

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.

SUMIF() UNIQUE()

How To Sort A Filter

This will allows you to analyze and organize your data.

Data validation Intermediate

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.

Life to Date

This is a review and improvement of Emmett Shear's Life to Date Sheet. Originally he tweeted about it and shared a sheet. I thought I could make it a bit better looking.

Twitter Sort Tool

I'll show you how I created a Twitter tool sort to organize my list of every tool I use to run better sheets.
Paste a list into Sheets and using a simple formula, I was able to determine the length of each item.

Then, I sorted the list in ascending order based on the length column. I even experimented with sorting it in descending order too!

Finally, I deleted the original list and pasted the sorted one using the "paste values" option. It's all done and ready to be shared. Check it out and let me know what you think! Don't forget to tweet about it if you find it helpful. Enjoy

Beginner

LEN() SORT()

Vertically Stack and Sort Data

It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.

Beginner

SORT()

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

DAY() MONTH() TODAY() YEAR()

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.

Advanced

Create a Many to Many Database

We have a list of names and maybe we have sort of a lead categories. Maybe we're doing sort of reach out and we want to actually maybe combine like key words.

FILTER() IFNA() JOIN() TRANSPOSE()

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.

Conditional Formatting Intermediate

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

ow do I show the date and time for the last time something was changed in a sheet? So what's interesting is that this This shows you Google Sheets shows an version history up here and shows you the last edit, but sometimes we want to have that data available to us inside of the sheet.

NOW()

Ben Asks: How Do I Add 1 Month?

Member Ben asks how to add 1 month to a date.

Intermediate

CONCATENATE() EDATE() TEXT() TODAY()

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.

Intermediate

INDEX() MATCH()

Concat Because Concatenate is too hard to Remember!

One more function beyond Concatenate and Join that is useful in so many different ways. Concat can be used to quickly create unique columns of data. But watch out for dates!

CONCAT() CONCATENATE() JOIN()

Displaying items 1-20 of 23 in total

TAGS

FORMULAS

TOPICS

23 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Ian Asks: How to sort dates by year/month (can't do with filter)

Find the Start date of the Current and End date of the Current Month

How Many Days Between Two Dates?

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

How To Filter Dates (They Are Numbers Too!)

Anders Asks: Find first and last of filter by date

Hardest Formula: SumIF | Addition Based on Dates / Values

How To Sort A Filter

Richard Asks: Copy Template Tab and Rename to Date Every Week

Life to Date

Twitter Sort Tool

Vertically Stack and Sort Data

Can I Automatically Rename a Sheet based on a Date?

How To Change Date Format Automatically

Create a Many to Many Database

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

Ben Asks: How Do I Add 1 Month?

David Asks: About Primary Keys

Concat Because Concatenate is too hard to Remember!