Hi ,
Your worksheet has dates in the range A4 : A8.
You want that these dates should be transposed to the cells L3 : P3.
When we want to access the value in A4 , we can use the formula :
=INDEX($A:$A , 4)
When we want to access the value in A5 , we can use the formula :
=INDEX($A:$A , 5)
Similarly , we can access the values in A6 , A7 and A8.
If we want to make the formula so that we can drag it across columns , we have to ensure that the second parameter changes from 4 to 5 to 6 to 7 to 8 automatically.
The easiest way is to use the COLUMN() function , since this will change automatically when a formula is dragged across.
When we enter a formula in cell L3 , we want the index number to be 4 ; since the COLUMN() function will return 12 when it is used in any cell in column L ( since column L is the 12th column ) , to get 4 all we need to do is subtract 8.
When this formula is dragged across to column M , the COLUMN() function will return the value 13 , and subtracting 8 from this will give us 5 ; in column N we will get 6 , in column O we will get 7 , and in column P we will get 8.
Narayan