WORKDAY.INTL Function – Google Sheets
Learn how the WORKDAY.INTL function calculates a future or past date based on a specified number of working days.
Date
DATEVALUE Function – Google Sheets
The DATEVALUE function accepts a date value in any valid format and returns it as a serial number. Spreadsheets store dates and times as serial numbers in Google Sheets, so they work in formulas (you can add March plus June). You can use the DATEVALUE function to prepare dates to be sorted, filtered, or used in formulas. … Read more
DATEDIF Function – Google Sheets
Learn how to use the DATEDIF function to find the number of years, months, or days between two dates.
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