In this post we are going to extract all "not empty" dates in a simple calendar. In a previous blog post we extracted only date ranges and names.
Here is a picture of the calendar.
Here is a picture of all extracted dates and corresponding "names".
Copy cell A2 and paste it down as far as needed.
Array formula in cell B2:
Copy cell B2 and paste it down as far as needed.
Download excel sample file for this tutorial.
(Excel 97-2003 Workbook *.xls)
Previous articles about cell blocks:
Functions in this article:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
SMALL(array,k) returns the k-th smallest row number in this data set.
ROW(reference) returns the rownumber of a reference
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range
DATE(year,month,day) returns the number that represents the datein Microsoft Office Excel date-time code