Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

years

How to Add or Subtract Years in Google Sheets

October 30, 2025December 24, 2024 Adam Steinfurth

Learn how to move dates forward for backward by whole years.

Categories Tutorials Tags date, edate, year, years

WEEKNUM Function – Google Sheets

August 25, 2023January 13, 2018 Adam Steinfurth

The WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. The date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a date. If your days, months, and years are in different cells, … Read more

Categories Date parts Tags date, function, months, subtract, weeknum, weeks, years

DATEDIF Function – Google Sheets

January 8, 2025January 13, 2018 Adam Steinfurth

Learn how to use the DATEDIF function to find the number of years, months, or days between two dates.

Categories Date parts Tags date, datedif, days, function, months, subtract, years
Calendar Importer

Start Your Free Trial
  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2025 Sheets Help • Built with GeneratePress