How to Add or Subtract Years in Google Sheets
Learn how to move dates forward for backward by whole years.
year
Types of Date and Time Functions in Google Sheets
The date and time functions in Google Sheets can be grouped into different categories based on their purpose.
YEARFRAC Function – Google Sheets
The YEARFRAC function takes two dates and returns the years between them, including fractions of a year. You can optionally specify different methods of counting days. This function can be used to calculate someone’s age. An alternative to YEARFAC is DATEDIF which can return the difference between two days in years, months, or days. To … Read more
YEAR Function – Google Sheets
The YEAR function extracts the year from a time value and returns it as a four-digit number. If you work with time but only care about the years, this function lets you eliminate everything else. ℹ️ Remember that dates are just saved as numbers by your spreadsheet with date formatting applied. Purpose The YEAR function … Read more
DATE Function – Google Sheets
Convert a month, day, and year to a date.