The Excel WORKDAY function's purpose is to return the serial number of the date before and after a specified number of workdays. Learn how to use it.

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.