J

#### Joe@excel

We have meetings every month. On Sunday’s and Wednesday

And every month we generate a task list for Sunday’s and Wednesday’s or

vise versa it all depends in the month. For example on November I would

have started on a Wednesday. For December I will start on a Sunday.

But it’s only for a month at a time.

A6=Data!F8

A7=IF(TEXT(A6,"dddd")="Sunday",A6+3,IF(TEXT(A6,"dddd")="Wednesday",A6+4))

A8=IF(TEXT(A7,"dddd")="Sunday",A7+3,IF(TEXT(A7,"dddd")="Wednesday",A7+4))

A9=IF(TEXT(A8,"dddd")="Sunday",A8+3,IF(TEXT(A8,"dddd")="Wednesday",A8+4))

A10=IF(TEXT(A9,"dddd")="Sunday",A9+3,IF(TEXT(A9,"dddd")="Wednesday",A9+4))

A11=IF(TEXT(A10,"dddd")="Sunday",A10+3,IF(TEXT(A10,"dddd")="Wednesday",A10+4))

A12=IF(TEXT(A11,"dddd")="Sunday",A11+3,IF(TEXT(A11,"dddd")="Wednesday",A11+4))

A13=IF(TEXT(A12,"dddd")="Sunday",A12+3,IF(TEXT(A12,"dddd")="Wednesday",A12+4))

A14=IF(TEXT(A13,"dddd")="Sunday",A13+3,IF(TEXT(A13,"dddd")="Wednesday",A13+4))

A15=IF(TEXT(A14,"dddd")="Sunday",A14+3,IF(TEXT(A14,"dddd")="Wednesday",A14+4))

A16=IF(TEXT(A15,"dddd")="Sunday",A15+3,IF(TEXT(A15,"dddd")="Wednesday",A15+4))

Data!F8 in this cell I enter the first day that we’ll meet.

For December 2005 right now, the result I get is as follows.

A6 Sunday 4 December 2005

A7 Wednesday 7 December 2005

A8 Sunday 11 December 2005

A9 Wednesday 14 December 2005

A10 Sunday 18 December 2005

A11 Wednesday 21 December 2005

A12 Sunday 25 December 2005

A13 Wednesday 28 December 2005

A14 Sunday 1 January 2006 ===) to avoid January to apper I tried the

following.

A15 Wednesday 4 January 2006===) to avoid these

A16 Sunday 8 January 2006===) to avoid these

A3 =COUNTIF(Sheet2!B6:B16,MONTH(F8))and it does gives me count of 8

B6=month(a6)

B7=month(a7)

B8=month(a8)

B9=month(a9)

B10=month(a10)

B11=month(a11)

B12=month(a12)

B13=month(a13)

B14=month(a14)

B15=month(a15)

B16=month(a16)

Then I go back to

A7=IF(TEXT(A6,"dddd")="Sunday",A6+3,IF(TEXT(A6,"dddd")="Wednesday",A6+4))

To A16 and enter the following to each.

A6=If(A3>=1,IF(TEXT(A6,"dddd")="Sunday",A6+3,IF(TEXT(A6,"dddd")="Wednesday",A6+4)),””)

A7=If(A3>=2

A8=If(A3>=3 Etc. until A16

But it’ll read that it can not do a circular formula. And wont do

anything..

Is there another way to do it?

Thank you…