Sam asks:

One more question for the Calendar that you have set up above can we have a excel formula which will give us a below table
StarWk EndWk Name
1 2 G
4 6 G
7 15 R ... and so on

Question found here.

Answer:

Array Formula in cell A2:

=SMALL(IF((Sheet1!$C$3:$AG$3<>Sheet1!$B$3:$AF$3)*(Sheet1!$C$3:$AG$3<>""), Sheet1!$C$2:$AG$2, ""), ROW(A1)) + CTRL + SHIFT + ENTER.

Copy cell A2 and  paste it down as far as needed.

Array Formula in cell B2:

=SMALL(IF((Sheet1!$C$3:$AG$3<>Sheet1!$D$3:$AH$3)*(Sheet1!$C$3:$AG$3<>""), Sheet1!$C$2:$AG$2, ""), ROW(A1)) + CTRL + SHIFT + ENTER.

Copy cell B2 and  paste it down as far as needed.

Array Formula in cell C2:

=INDEX(Sheet1!$C$3:$AG$3, SMALL(IF((Sheet1!$C$3:$AG$3<>Sheet1!$B$3:$AF$3)*(Sheet1!$C$3:$AG$3<>""), Sheet1!$C$2:$AG$2, ""), ROW(A1))) + CTRL + SHIFT + ENTER.

Copy cell C2 and  paste it down as far as needed.

Download excel sample file for this tutorial.

Extract dates and name from block schedule.xls
(Excel 97-2003 Workbook *.xls)

Previous articles about cell blocks:

Functions in this article:

IF(logical_test;[value_if:true];[value_if_false])
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

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range