+ Reply to Thread
Results 1 to 4 of 4

Add days to a date, but display following Monday if result falls on a weekend

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Add days to a date, but display following Monday if result falls on a weekend

    So for instance:

    Today = 16/05/23

    Add 5 days to this date = 21/05/23

    This is a Sunday, so I'd like to to display the Monday, so: 22/05/23
    I know =workday exists, but Id like it to count weekends as days, but not give them as the notification date.

    Hope that makes sense!
    Last edited by Barking_Mad; 05-16-2023 at 06:13 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Add days to a date, but display following Monday if result falls on a weekend

    does this work
    =A2+5+(WEEKDAY(A2+5)=7)*2+(WEEKDAY(A2+5)=1)*1

    otherwise
    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

    Here are the instructions, found at the top of the page again
    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: Add days to a date, but display following Monday if result falls on a weekend

    Hi, cheers, that looks great, thanks so much for your help. Sorry for not including a workbook, forgot (again!)

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Add days to a date, but display following Monday if result falls on a weekend

    you are welcome - maybe a simpler formula available - but as you are on 2019 version , you dont have a lot of the new functions

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Have cell display Monday/Friday date if a date falls on the weekend
    By tcdccinc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2022, 03:09 PM
  2. Replies: 2
    Last Post: 08-22-2020, 11:19 AM
  3. [SOLVED] Calculate Calendar Days Ahead, but if weekend or holiday result the earliest weekday
    By Alphabex in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2018, 01:25 PM
  4. Replies: 12
    Last Post: 06-13-2014, 05:03 PM
  5. [SOLVED] Rounding weekend days to monday
    By ScottLor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-17-2013, 10:54 AM
  6. if "x" days is more fall on weekend return following monday
    By jermsalerms in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2006, 07:47 PM
  7. Formula has to take Monday if due date falls on a Sunday
    By Revathi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-28-2006, 07:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1