Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Let’s Talk 💬
  • Add-Ons

function

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

ISOWEEKNUM Function – Google Sheets

October 8, 2023January 13, 2018 Adam Steinfurth

The ISOWEEKNUM function accepts a date and returns the ISO week number (1 through 54) of that date. The date must be in a valid format, so you must use the DATE function, wrap it in quotes, or use a cell reference to a cell containing a date. An ISO week starts on Monday. The … Read more

Categories Date, Date parts Tags date, function, iso, isoweeknum, weeks

WEEKDAY Function – Google Sheets

September 24, 2024January 13, 2018 Adam Steinfurth

The WEEKDAY function accepts a date and returns the number for the day of the week. 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 cell containing a date. If your days, months, and years are in … Read more

Categories Date parts Tags date, dayofweek, function, weekday, weeks

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

DATE Function – Google Sheets

May 1, 2023December 24, 2016 Adam Steinfurth

Convert a month, day, and year to a date.

Categories Date parts Tags date, day, function, month, year
Newer posts
← Previous Page1 … Page3 Page4
StaySorted moving a row automatically

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