Auto fill cells with dates, exclude weekends?

S

Sam Weber

What I'm doing is filling in multiple cells with dates
(by dragging and filling) automatically. I was wondering
if there was anyway for it to skip the weekends within
the dates?

Thanks in advance.
 
J

JulieD

Hi Sam

rather than dragging with the left mouse button down, drag with the right
.... when you let go you'll see an option for fill weekdays.

Cheers
JulieD
 
F

Frank Kabel

Hi
if A1 is your starting date enter the following in A2:
=WORKDAY(A1,1)
and copy down
 
J

JE McGimpsey

When you drag, right-click instead of left-click. When you release the
button, choose Fill Weekdays from the popup menu.
 
Top