title: Excel - apply function to range of cells in a column
body: <p>I have a column <code>A</code> with dates which has 1000 entries. I want <code>Bi = Weekday(Ai)</code> for all <code>i &lt;= 1000</code>. How can I apply the method to only 1000 cells in column B and not more(without dragging)?</p>