1. TODAY/NOW. There are 24 Date and Time functions listed on the drop-down menu under Formulas > Date & Time: 11 Date formats, 10 Time formats, and as many user-defined custom formats you can create.

Identify the column whose data you want Excel to find in a different array. With this example, ... using both functions. With this example, the formula finds a product code in the array.

Here’s a simple example explaining how the new SORT array function works. Columns A and B in the screenshot below (cells A3:B17) contain unsorted sales data by state. To sort these data using a ...