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
Show a Date as a Month Name – Google Sheets
Learn two methods to display your dates as the month’s name in your spreadsheet.
TYPE Function – Google Sheets
The TYPE function checks a cell and returns the data type as an integer. Several types of data are allowed in a Google Sheet, and knowing the type helps you understand how to use it. More specific functions are available to determine a cell’s data type, but they only return TRUE or FALSE. For example, … Read more
Understanding Data Types in Google Sheets
Learn about the different types of data you can use in a spreadsheet.
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