Getting the next week from a date

[jscranton]

If I have a date in Cell A1 and I want to get the start date of the next week, how is that possible?

So: A1 shows 7/26/2019.

I want B1 to display 7/29/2019 (week begins on Monday).

I know it is some combination of WEEK and DAY but not sure how to do it.

 

[Rick Rothstein]

Give this formula a try...

=A1-WEEKDAY(DAY(A1))+8

 

[Aryatect]

Hi, Try:

=WORKDAY.INTL(A1,1,"0111111")

 

[Tetra201]

See if the following formula works for you:

=INT((A1+5)/7)*7+2