Basics

Pivot Table Formatting in Google Sheets (3 Easy Ways)

Pivot tables are perhaps one of the most important data presentation tools that a spreadsheet application can have. The focus word here is ...

How to Sort a Pivot Table in Google Sheets (An Easy Guide)

Many ask the question: Can you sort data in a Pivot Table in Google Sheets? The answer is a resounding yes. While simple, there is ...

How to Insert a Timestamp in Google Sheets (An Easy Guide)

In this tutorial, we will look at how we can insert a timestamp in Google Sheets. There are multiple approaches we can take, taking into ...

How to Apply a Date Picker in Google Sheets (An Easy Guide)

Spreadsheet applications like Google Sheets rely heavily on dates having the correct format since wrong dates entered can have huge implications ...

How to Use the DATE function in Google Sheets (An Easy Guide)

In this simple tutorial, we take a deep dive into the DATE function of Google Sheets. We will discuss its importance and see a few of its uses as ...

How to Format Date with Formula in Google Sheets (3 Easy Ways)

Date formats in Google Sheets usually depend on the regional or locale settings. Most commonly mm/dd/yyyy for the United States and dd/mm/yyyy for ...

Generate Automatic Date in Google Sheets (3 Easy Ways)

In this tutorial, we will show you how to insert or generate an automatic date in Google Sheets. While the task itself is quite simple, it is the ...

Apply an Automatic Timestamp Using Google Sheets Script (3 Easy ways)

In this tutorial, we will look at how we can apply an automatic timestamp in Google Sheets using Apps Script. But first, let’s start with the basics. ...

How to Autofill Date in Google Sheets (A Comprehensive Guide)

This article looks to serve as a comprehensive guide discussing all the ways we can use to autofill a date in Google Sheets, starting from simple ...

Autofill Date when a Cell is Updated in Google Sheets (3 Easy Ways)

This is a simple guide to show you a few ways you can use to autofill a date when a cell is updated in Google Sheets. While there are functions and ...

How to Sum a Duration of Time in Google Sheets (An Easy Guide)

In this article, we will discuss how to sum the duration of time in Google Sheets. At first glance, the idea may seem simple, but a certain level of ...

How to Autofill or Continue Dates in Google Sheets (An Easy Guide)

One of the best features that Google Sheets has to offer is its autofill feature. It is smart enough to understand what type of data the user needs ...

How to Use the EOMONTH Function in Google Sheets (An Easy Guide)

If you want to generate the last day of a month which falls before or after a specified number of months, then the EOMONTH function of Google Sheets ...

Find Number of Days in a Month in Google Sheets (An Easy Guide)

Finding the number of days in a month in Google Sheets is a matter of simply understanding how the application perceives dates and using a ...

How to Use the DATEVALUE Function in Google Sheets (An Easy Guide)

The DATEVALUE function is a great way to extract or generate the underlying date code of a date in Google Sheets. This date code is the raw ...

OfficeWheel
Logo