Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
funtions and conditions
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 |