Working with a date modification

[dbarbella]

Hi all,
I'm using this in Google Sheets.

I have two working formulas:

Take date in A1, and change to the next coming Friday in the calendar
=$A1+6-MOD(WEEKDAY($A1),7)

There is one anomaly that I can't seem to work out.

• If A1 equals a Friday, then the formula shows the same day as being the next Friday.
  • so if A1 = 9/7/2018, it is returning 9/7/2018

How can I make that formula not choose the same Friday as A1, but the following Friday?
if A1 = Friday 9/7/2018, then the formula should return 9/14/2018

(and of course, 9/6/2018, would return 9/7/2018)

I'm looking to get that formula for finding the Next Thursday, and the Next Friday of A1
(two different formulas, that will be in different cells).

Thanks so much
-Dave

 

[Rick Rothstein]

I think this formula will do what you want...

=$A1+7-MOD(WEEKDAY($A1)+1,7)

 

[dbarbella]

Thank you so much Rick, that did it.

I attempted to modify it for the Thursday version of the same, but was unsuccessful (Worked for some original days of the week, but not all).

Is there a Thursday variation of the same?

 

[Rick Rothstein]

I attempted to modify it for the Thursday version of the same, but was unsuccessful (Worked for some original days of the week, but not all).

Is there a Thursday variation of the same?

This seems to work...

=$A1+7-MOD(WEEKDAY($A1)+2,7)

 

[dbarbella]

Thanks so much Rick,
I was attempting to modify the wrong portion of the formula