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

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?

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

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" wrote in message
...
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?

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

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?