I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010
(Friday) but I need to skip Saturday and Sunday. Is there an easy way to do
this?

Hi,

With your start date in a1, put this in B1 and drag down

=WORKDAY(A1,1)

If you get the name error then Tools\Addins and check the analysis toolpak

or without the ATP

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

Mike

"Confusicous" wrote:

> I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010
> (Friday) but I need to skip Saturday and Sunday. Is there an easy way to do
> this?

One way........
1-Fill the cells down for the year including the Saturdays and Sundays
2-Re-format the column to "Custom > dddd" so the names of the days will show
3-Data > Filter > Autofilter and choose "Saturday" from the dropdown
4-Delete those rows
5-Choose "Sunday" from the dropdown
6-Delete those rows
7-Data > Filter > Autofilter to return to normal
8-Reformat the column for the date style you prefer.

Vaya con Dios,
Chuck, CABGx3




"Confusicous" <(E-Mail Removed)> wrote in message
news1BBD2D2-9B39-420D-A0D7-(E-Mail Removed)...
>I need to start with the date 12/28/2009 (monday) and drag down to
>12/31/2010
> (Friday) but I need to skip Saturday and Sunday. Is there an easy way to
> do
> this?

Thanks a ton! Worked perfectly

"Mike H" wrote:

> Hi,
>
> With your start date in a1, put this in B1 and drag down
>
> =WORKDAY(A1,1)
>
> If you get the name error then Tools\Addins and check the analysis toolpak
>
> or without the ATP
>
> =A1+1+CHOOSE(WEEKDAY(A1+1,2),0,0,0,0,0,2,1)
>
> Mike
>
> "Confusicous" wrote:
>
> > I need to start with the date 12/28/2009 (monday) and drag down to 12/31/2010
> > (Friday) but I need to skip Saturday and Sunday. Is there an easy way to do
> > this?

If that don't beat all............pretty cool Mike

Vaya con Dios,
Chuck, CABGx3




"Mike H" <(E-Mail Removed)> wrote in message
news:3F42FCCC-70A4-4E10-92C7-(E-Mail Removed)...
> Hi,
>
> With your start date in a1, put this in B1 and drag down
>
> =WORKDAY(A1,1)
>
> If you get the name error then Tools\Addins and check the analysis toolpak
>
> or without the ATP
>
> =A1+1+CHOOSE(WEEKDAY(A1+1,2),0,0,0,0,0,2,1)
>
> Mike
>
> "Confusicous" wrote:
>
>> I need to start with the date 12/28/2009 (monday) and drag down to
>> 12/31/2010
>> (Friday) but I need to skip Saturday and Sunday. Is there an easy way to
>> do
>> this?