+ Reply to Thread
Results 1 to 6 of 6

Adding 4 days into the date today minus the weekend

  1. 05-19-2015, 10:59 AM #1
    geliedee
    geliedee is offline
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Adding 4 days into the date today minus the weekend

    Hi All,

    I have to add 4 days into the date today but excluding the weekend.

    For example:
    April 22, 2015 + 4 days (excluding the weekend is = April 28 2015


    Any one can help?
    Reply With QuoteRegister To Reply
  2. 05-19-2015, 11:08 AM #2
    acroley1
    acroley1 is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Adding 4 days into the date today minus the weekend

    =workday(a1,4) (assuming your data in in cell A1)
    Last edited by acroley1; 05-19-2015 at 12:23 PM.
    Reply With QuoteRegister To Reply
  3. 05-19-2015, 11:10 AM #3
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Adding 4 days into the date today minus the weekend

    Assunming you have a Sat-Sun weekend, use:

    =WORKDAY(A1,4)
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  4. 05-19-2015, 11:10 AM #4
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Adding 4 days into the date today minus the weekend

    Acroley.. Snap!!
    Reply With QuoteRegister To Reply
  5. 05-19-2015, 11:55 AM #5
    acroley1
    acroley1 is offline
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Adding 4 days into the date today minus the weekend

    Quote Originally Posted by Glenn Kennedy View Post
    Acroley.. Snap!!
    haha Too slow GK
    Reply With QuoteRegister To Reply
  6. 05-22-2015, 09:44 AM #6
    geliedee
    geliedee is offline
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Re: Adding 4 days into the date today minus the weekend

    Thanks y'all!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 3 days prior to today minus weekends and holidays
    By Thunderer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2014, 09:54 PM
  2. [SOLVED] Macros for: If Today's Date minus other date is greater than certain amount of days Then
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-24-2012, 04:46 PM
  3. Today's date minus two
    By mldardy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2011, 11:51 AM
  4. add days without adding weekend
    By brian thompson3001 via OfficeKB.com in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 03-08-2006, 01:10 PM
  5. Excel running date formula minus weekend days
    By Eliane in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2005, 06:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1