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
DAY Function – Google Sheets
The DAY function is a simple date function that extracts just the day from a given time. If you work with times but only care about the day, this function lets you get rid of everything else. Typically you will find this function combined with others to return a number for further calculation. This function … Read more
DAYS Function – Google Sheets
The DAYS function calculates the number of days between two dates.