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

Answer:

sort-dates-within-a-date-range-using-excel-array-formula2

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 within a date range using conditional formatting

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

Comments(15) Filed in category: Conditional formatting, Excel

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.

Comments(2) Filed in category: Count values, Excel

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 […]

Comments(2) Filed in category: Dates, Excel

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 in excel

In this post I am going to explain the dynamic named range formula in Sam's comment. The formula adds new rows and columns […]

Comments(12) Filed in category: Excel, Named range

Download excel example file

sort-dates-within-a-date-range-using-excel-array-formula.xls
(Excel 97-2003 Workbook *.xls)

Functions used in this blog post

SMALL function and LARGE function

This function lets you extract any number in a cell range based on sort rank.

Comments(12) Filed in category: Excel

IF function explained

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

Comments(9) Filed in category: Excel