How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can also use this dynamic duo to perform two-way lookups, returning a value at ...