Date formula/help

[Confusicous]

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?

 

[Mike H]

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

 

[clr]

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]

Thanks a ton! Worked perfectly

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

 

[clr]

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

Vaya con Dios,
Chuck, CABGx3