Auto fill cells with dates, exclude weekends?

  • Thread starter Thread starter Sam Weber
  • Start date Start date
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.
 
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
 
Hi
if A1 is your starting date enter the following in A2:
=WORKDAY(A1,1)
and copy down
 
When you drag, right-click instead of left-click. When you release the
button, choose Fill Weekdays from the popup menu.
 
You must log in or register to reply here.

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

Similar Threads

Date filling down 3
Date Formula Excluding Weekends 3
Change Default Auto-Fill-In month 4
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Auto-populate other cells based on dates 2
Date and If problem 6
Date + X days excluding holidays 1
Fill handle increments year instead of day 1

Back
Top