Say Monday is in A2, Tuesday in B2 etc.
I used Sheet2!A1 as the input field
In A2 enter : =IF(WEEKDAY(Sheet2!$A$1)<1,"",Sheet2!$A$1)
In B2 enter : =IF(A2<"",A2+1,IF(WEEKDAY(Sheet2!$A$1)<2,"",Shee t2!$A$1))
In C,D and E2, increment the <2 by 1, ie 3,4 and 5
The next Monday, enter =IF(E2<"",E2+3,"").
For the remainder of the next week, add 1 to the previous day, eg
=IF(F2<"",F2+1,"").

I have not included holidays though.
--
Hth

Kassie Kasselman


"christine b" wrote:

I'm trying to create a sheet that will auto fill in dates based on a user
entered start date. the sheet is set up in a calendar fashion (for a course
schedule), so the dates need to be filled begining with the start date... ie,
start filling on wednesday if the start date entered is in fact a wednesday.
The user entry data is on another sheet.
Can someone help me build a formula that will do the following, or suggest
an easier way???

Monday will: evaluate the startdate, if it is a monday it shows the date,
if not it leaves it blank.
Tuesday will: evaluate the startdate, if it is tuesday it shows the date,
if the start date is monday it shows the date for tuesday (monday + 1),
otherwise it stays blank.
Wednesday, Thurs, Friday, will do the same as above.
The following Monday should just take the date from Friday and +1. Each day
of the week after this should also just +1.

The catch is also to leave any date that is a holiday is to be left blank (I
have a holiday list) so that I can set a condition to format the cells grey.

I know its complicated, yet I've seen a simular schedule work this way.
Just do not have access to it to use it as a reference.

Thanks to anyone who can help.

Christine