Getting the next week from a date
Results 1 to 4 of 4

Thread: Getting the next week from a date
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2011
    Location
    Raleigh, NC
    Posts
    686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Getting the next week from a date

    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.
    60% of the time it works every time.

  2. #2
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,103
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Getting the next week from a date

    Give this formula a try...

    =A1-WEEKDAY(DAY(A1))+8
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  3. #3
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    308
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Getting the next week from a date

    Hi, Try:

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

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  4. #4
    MrExcel MVP Tetra201's Avatar
    Join Date
    Oct 2016
    Posts
    3,372
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Getting the next week from a date

    See if the following formula works for you:

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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •