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