Article updated on January 18, 2018

Question: I have a list of unsorted dates. I want to extract records between two dates and I want the extracted dates sorted?



Array formula in D5:

=SMALL(IF((List<=end_date)*(List>=start_date), List, ""), ROW(A1))

The following article demonstrates how to highlight dates in a date range:

Highlight dates in a date range

Question: How do I highlight dates that meet criteria using conditional formatting? Table of contents Highlight values in a column […]

How to create an array formula

  1. Copy array formula
  2. Select cell D5
  3. Paste formula in formula bar
  4. Press and hold Ctrl + Shift
  5. Press Enter

Learn the basics of Excel arrays

Array formulas allows you to do advanced calculations not possible with regular formulas.

How to copy array formula

  1. Select cell D5
  2. Copy (Ctrl + c)
  3. Select cell range D6:D15
  4. Paste (Ctrl + v)

Recommended article:

Filter weeks from a date range

Deeks asks: need to truncate the undermentioned column to create columns of weeks it has, for eg. 1/26/2011 was a […]

Named ranges

List (A1:A10)
List_start (A1)
sorted_list_start (D5)
start_date (E1)
end_date (E2)

Recommended article:

Create a dynamic named range

A dynamic named range grows automatically when new values are added and also shrinks if values are deleted. This saves […]

Download excel example file

(Excel 97-2003 Workbook *.xls)

Functions used in this blog post

How to use the SMALL function

The SMALL function lets you extract a number in a cell range based on how small it is compared to the other numbers in the group.

How to use the IF function

Checks if a logical expression is met. Returns a specific value if TRUE and another specific value if FALSE.