Functions & Formulas

The DATE function

The DATEVALUE function

The DAY function

The DAYS function

The EDATE function

The EOMONTH function

The HOUR function

The MINUTE function

The MONTH function

The NETWORKDAYS function

The NOW function

The SECOND function

The TIME function

The TIMEVALUE function

The TODAY function

The WEEKDAY function

The WEEKNUM function

The WORKDAY function

The YEAR function

The YEARFRAC function

The ISBLANK function

The ISERROR function

The ISEVEN function

The ISFORMULA function

The ISLOGICAL function

The ISNONTEXT function

The ISNUMBER function

The ISODD function

The ISTEXT function

The AND function

The IF function

The IFERROR function

The IFS function

The NOT function

The OR function

The SWITCH function

The COLUMN function

The COLUMNS function

The HLOOKUP function

The INDEX function

The LOOKUP function

The MATCH function

The OFFSET function

The ROW function

The ROWS function

The VLOOKUP function

The XLOOKUP function

The SUM function

The SUMIFS function

The SUMPRODUCT function

The ROUND function

The ROUNDUP function

The ROUNDDOWN function

The AVERAGE function

The AVERAGEA function

The AVERAGEIFS function

The COUNT function

The COUNTA function

The COUNTBLANK function

The COUNTIFS function

The FREQUENCY function

The LARGE function

The MAX function

The MEDIAN function

The MIN function

The MODE.MULT function

The MODE.SNGL function

The QUARTILE.EXC function

The QUARTILE.INC function

The SMALL function

The CONCAT function

The EXACT function

The FIND function

The LEFT function

The LEN function

The MID function

The PROPER function

The REPLACE function

The RIGHT function

The SEARCH function

The SUBSTITUTE function

The TEXT function

The TEXTJOIN function

The TRIM function