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

E

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?
 
B

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
 
B

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.
 
Top