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
WORKDAY Function – Google Sheets
The WORKDAY function calculates a workday that is a given number of days away from a date. You can optionally specify a list of holidays to exclude from the count. ? If your days, months, and years are in different cells, use the DATE function to combine them. Syntax =WORKDAY(start_date,days,[holidays]) Video Tutorial Related Functions WEEKDAY … Read more
MONTH Function – Google Sheets
Return the month from a date.