Recurring Date to Fall on Specific Day

Jessica Zell

Hi -

I've set up two columns "Cadence" and "Launch Date". For the top row of my sheet, I've listed the start date of the month (i.e. November 2) under the Launch Date for formula purposes.

From there, on another row, I have a task where it should be completed 3 weeks after the start date of the month, but fall on a Friday.

The current formula =[Launch Date]1 + Cadence23 works well (and leads me to November 23), but the date falls on Tuesday, where I need it to fall on a Friday.

Any idea how to adjust the formula?

Thanks!

Jessica

Leibel S

Jessica,

Not exactly clear of your setup but if you wanted the end date always on Friday you would use the WEEKDAY formula.

The below is an example of this. This adds 3 weeks to a [Start Date] column then pushes it up to the coming Friday.

=IF(WEEKDAY([Start Date]@row + 21) = 7, [Start Date]@row + 27, [Start Date]@row + 21 + (6 - WEEKDAY([Start Date]@row)))

Leibel S

Jessica,

Not exactly clear of your setup but if you wanted the end date always on Friday you would use the WEEKDAY formula.

The below is an example of this. This adds 3 weeks to a [Start Date] column then pushes it up to the coming Friday.

=IF(WEEKDAY([Start Date]@row + 21) = 7, [Start Date]@row + 27, [Start Date]@row + 21 + (6 - WEEKDAY([Start Date]@row)))

Jessica Zell

That worked perfectly, THANK YOU Leibel!