Your Guide to Date Functions (Google Sheets/Excel)

In this article, I will list many of the date functions you’ll need to do basic things.

There are a few things you need to know as dates.

Date Values

Each date, for example, October 24, 2018, has an assigned Date Value, which in this case, is 43397. The Date Value’s “0” value is on December 30th, 1899. The Date Value increments by 1 per day, and it can go into the negatives. For example, January 1st, 1800 is -36522. These Date Values will be handy in the future.

However, let’s begin by discussing the format of dates.

Read more