Setting a Specific Day of the Week in a Timeline

aplunkett02

I am creating a timeline template and need the Mid-Campaign report line to always fall on a Thursday. Is there a way to "round" the date to the next Thursday without manually updating it? For example, if the Mid-campaign is supposed to be delivered on a Monday according to the standard timing, it would be adjusted the Thursday later that week.

An example of this timeline is shown below:

Paul Newcome

It looks like you are using dependencies, so unfortunately this is going to be a manual process. We can use a sheet summary field with a formula to output the date you need to enter, but I'm not sure that's any easier than just clicking in the cell's calendar.