How do I auto fill a date series

  • Thread starter Thread starter Mickky
  • Start date Start date
M

Mickky

Hi

I looking for some help with filling in a series of dates.
I am using Excel 2003.

I would like to auto-fill in a series of dates starting with a Monday and ending on a Saturday over a 3-month period..
The auto fill series allows me to tick the weekday box but this removes Saturday and Sundays; i need the Saturday included.
Can you help?

Thanks
Mick


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
 
Put your first date in the top cell (I used A1, but you don't need to):

Then in the cell below it, use a formula like:
=A1+1+(WEEKDAY(A1)=7)

And drag down as far as you need.

This formula is equivalent to:
=A1+IF(WEEKDAY(A1)=7,2,1)
or this:
=A1+IF(TEXT(A1,"DDD")="Sat",2,1)

So you're adding 1 or 2 to the cell above based on if that cell is a Saturday or
not.

You can convert the formulas to values if you want.
 
Back
Top