DATEDIF Function – Google Sheets
Learn how to use the DATEDIF function to find the number of years, months, or days between two dates.
date
ISOWEEKNUM Function – Google Sheets
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
WEEKNUM Function – Google Sheets
The WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. To calculate the week number, 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 … Read more
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
MONTH Function – Google Sheets
Return the month from a date.