View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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?