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
DATE Function – Google Sheets
Convert a month, day, and year to a date.