Ads

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.