Date formula/help

C

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

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
 
C

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
 
C

Confusicous

Thanks a ton! Worked perfectly

Mike H said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top