On Thursday, May 15, 2003 at 1:19:23 PM UTC-6, Myrna Larson wrote:
What pattern do you want? Just Tues and Thurs every week? Excel can't handle that with automatic
incrementing since the increment is 2, 5, 2, 5, etc.

You can do it with a formula:

Put the first date (a Tue or Thu) in A1. In A2

=A1+IF(WEEKDAY(A1)=3,2,5)

and copy down.


On Thu, 15 May 2003 05:53:39 -0700, "John" wrote:

or Monday Wednesday...

if i enter a date in one cell and then drag the cell it
will want to enter dates sequentially...but there must be
some easy way to enter a different pattern...

help! thanks in advance!

:)

This was very helpful, thank you! :)