Question: to help anyone a little better with dates like this than I am...

You say "The following Monday should just take the date from Friday and +1.."

"+1"?? Shouldn't Monday be +3 days after a Friday? Or did you mean +1
something else (not days).

"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