How do I set up a clumn of days, skipping weekends?

[Enrique]

I'm looking for a way to have a continuous column of numbers vertically, and
when the date hits a weekend, it will skip to the following Monday. Is this a
possibility?

[Biff]

Hi!

Here's one way:

Enter the first date in the first cell:

A1 = 1/2/2006 (Monday)

Enter this formula in A2 and copy down as needed:

=A1+CHOOSE(WEEKDAY(A1,2),1,1,1,1,3,2,1)

Biff

"Enrique" <Enrique@discussions.microsoft.com> wrote in message
news:F16F7D00-B8C4-472E-BC81-46BA57F2B52E@microsoft.com...
> I'm looking for a way to have a continuous column of numbers vertically,
> and
> when the date hits a weekend, it will skip to the following Monday. Is
> this a
> possibility?

[bpeltzer]

Enter the first five dates (weekdays only). If these are in A2:A6, select A7
and enter the formula =A2+7. Copy that formula down as far as you need.

"Enrique" wrote:

> I'm looking for a way to have a continuous column of numbers vertically, and
> when the date hits a weekend, it will skip to the following Monday. Is this a
> possibility?