The obvious question from yesterdays blog post is: How to customize formula to extract dates for all months in calendar?
(I have added more data to the calendar since yesterday)
Array formula in A2:
Copy cell A2 and paste it down as far as needed.
Array formula in B2:
Copy cell B2 and paste it down as far as needed.
Array formula in C2:
Copy cell C2 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:
- Extract dates from a cell block schedule in excel
- Count cell blocks in excel
- Count overlapping dates in excel
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