Date filling down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to fill a date down many cells but it fills weekends as well. is there way to fill down a date, excluding weekends?
 
Enter your date in a cell.
Select the cell, and *right click* and drag down to copy as needed.

When you release the *right* mouse button, you see a dialog box with
numerous options, one of which, is to fill the series with *weekdays*.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

i want to fill a date down many cells but it fills weekends as well. is
there way to fill down a date, excluding weekends?
 
Rightclick on the autofill button and drag down. When you let go, you'll see
some options that you like!
 
thanks guys, great stuff!

Dave Peterson said:
Rightclick on the autofill button and drag down. When you let go, you'll see
some options that you like!
Click to expand...
 
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

Fill handle increments year instead of day 1
Excel Macro to automatically go to the right of the last colored cell 0
Change Default Auto-Fill-In month 4
Auto fill not working 2
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Series fill only copying and fill series greyed out 1
Excel 2003 - fill down error 1
Fill handle fill down alternative methods question 2

Back
Top