Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

subtract

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

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
StaySorted moving a row automatically

Get the Google Sheets Add-On
  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2025 Sheets Help • Built with GeneratePress