automatically putting in dates like tuesday/thursday
 

Myrna,

Thank you!!! Your formula worked perfectly for what I needed, using Sheet1's cell B1 as the start date.

However, I am now trying to exclude specific dates calculated in my Sheet2's cells A3:A12, and I'm having trouble joining the two calculations. I've looked online, but all other topics discuss excluding weekends and don't take into account the WEEKDAY formula for Tuesdays/Thursdays.

Help! :|

Best,
Gaby

On Thursday, May 15, 2003 at 3:22:25 PM UTC-4, 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!

:)