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.
The YEARFRAC function calculates the number of years between two dates, returning the result as a decimal (fraction).
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.