List only business days when auto filling in excel

Suppose you want to create a scorecard for work and you  need to auto fill dates but don't need weekends.

Is it possible to click and drag the auto fill and accomplish this?

Well the answre is yes!! 

In Excel 2007:

1.Enter the first date in a cell

2.Select the range of cells in the column or row you want to fill including the cell with the first date

3.Select Home --> In Editing choose Fill --> Series...

4.Choose Type = Date then Date Unit = Weekday

5.Select OK.

Excel Formulae: Letters In Sequence : A, B, C.....

I would like to create a column with letters from alphabet in a sequence.

If I write A and in cell below I put B then highlight the two cells and drag down I get a repetition of A and B.

How do I get the following alphabet letters ie. C,D, E etc.?

If you type the first letter into first cell (say A1), then below:

=CHAR(CODE(LEFT(A1,1))+1)

copy down ...

note once you get beyond Z you will get odd results, do you plan to go beyond Z and if so what should succeed Z ... if it is AA you can revert to an ADDRESS approach.

 

For example:

Say first letter was always A and was to start in A1:

=SUBSTITUTE(ADDRESS(1,ROWS(A$1:A1),2),"$1","")

copy down as far as required --

27th entry would become AA, 28th AB etc...

-->

T8ZU3RT4ER6Z