Hi, Need 2 make a schedule with some events taking place on a specific day of the week

Hi all, hope someone can help me with this.

I need to make a schedule based on a "start date" that list the date of the events that need to be completed prior to the "start date". Some of these events need to occur on a specific date of the week.

I am able to use simple arithmetic with dates and the Weekday() function to get the dates of those prior events. But I can't figure out how to get an event to happen on a specific day of the week no matter the "start date" (i.e. Data uploads every Thurs).

Can somebody please help???

Thanks a ton.

Can you post a sample workbook to understand in detail????

Here's what I'm trying to do. My use of the =weekday() function didn't work as flawlessly as I thought.


But I want the date for the "user data upload" to always be a Thurs and the other dates to be a weekdays.

Ok, I've made some adjustments to workbook and almost have it. The problem I have now is
getting a calculated date to round to the next Thurs. I'm able to get the day to change to a Thurs but the month, day and year are also changing. I've included a new copy of the
workbook. I'm trying to change "D15". The date should come out as "Thurs - 20-Dec-2012". Someone please help.