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.
Array Formula in cell A2:
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.
Array Formula in cell C2:
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:
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