EDATE Function – Google Sheets
The EDATE function increments a starting date by a specified number of months.
date
EOMONTH Function – Google Sheets
EOMONTH is a function in Google Sheets that returns the ending day of a specified month. If you have many dates in your spreadsheet, this formula lets you quickly find the last day of the month in an automated fashion. Once you have the last day of the month, see here if you want to … Read more
DATE Function – Google Sheets
Convert a month, day, and year to a date.
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
Google Sheets Date Formulas: Calculate, Format & Fix Dates
Learn the nuances of working with dates and times in Google Sheets.