Date filling down

[Stefano]

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?

 

[RagDyer]

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?

 

[Dave Peterson]

Rightclick on the autofill button and drag down. When you let go, you'll see
some options that you like!

 

[Stefano]

thanks guys, great stuff!

Rightclick on the autofill button and drag down. When you let go, you'll see
some options that you like!