+ Reply to Thread
Results 1 to 15 of 15

i would like to do a future ship date using =TODAY()+x but i dont want weekends included.

  1. 05-28-2013, 11:47 AM #1
    Legend Rubber
    Legend Rubber is offline
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    i would like to do a future ship date using =TODAY()+x but i dont want weekends included.

    Is it possible to skip weekends while putting a future ship date... for example...
    can i do 
    Please Login or Register  to view this content.
    but skip weekends?
    Reply With QuoteRegister To Reply
  2. 05-28-2013, 12:13 PM #2
    Cheeky Charlie
    Cheeky Charlie is offline
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    Yep, you need to install the analysis toolpak if not already done.
    http://office.microsoft.com/en-gb/ex...001127724.aspx
    Then:
    =Workday(Start date,days,holidays)

    The help explains all the arguments. Your example would be =workday(today(),5)
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
    Reply With QuoteRegister To Reply
  3. 05-28-2013, 12:13 PM #3
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    Hi Legend,
    Do you want to skip only Sunday or Saturday + Sunday
    Cheers,

    Joshi
    Being with a winner makes you a winner
    Reply With QuoteRegister To Reply
  4. 05-28-2013, 12:14 PM #4
    nemo74
    nemo74 is offline
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    Good morning Legend

    how does this sound?

    Please Login or Register  to view this content.
    Replace the 5 with the days you want from today.
    Reply With QuoteRegister To Reply
  5. 05-28-2013, 12:42 PM #5
    Legend Rubber
    Legend Rubber is offline
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    thanks, now can you tell me if there is a way to round to the nearest whole number, but always round down... so if it were 5.55 it would round to 5.
    Reply With QuoteRegister To Reply
  6. 05-28-2013, 12:48 PM #6
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    Hi

    See below

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-28-2013, 01:14 PM #7
    Legend Rubber
    Legend Rubber is offline
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    OK, GETTING THERE...what if i want to do all the workdays in any given month without doing it manually...
    i want to type the year in one box, the month in the other, and the first working day to pop up...
    Reply With QuoteRegister To Reply
  8. 05-28-2013, 01:25 PM #8
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    So what has 5.5 got to do with the workday function!
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)
    Reply With QuoteRegister To Reply
  9. 05-28-2013, 01:36 PM #9
    Legend Rubber
    Legend Rubber is offline
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    read up a little... i skipped back to part of my original problem...
    i am setting future dates for shipping and follow-up... so i am using an equation to find out a number of days, but the answer to the equation is not always a whole number, therefor i needed something to round it down... which i got...
    now i am back to solving the total problem... 5.5 had nothing really to do with it, just an example for a sub-problem.
    Reply With QuoteRegister To Reply
  10. 05-28-2013, 01:40 PM #10
    Cheeky Charlie
    Cheeky Charlie is offline
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    I don't see how this is related either, but...
    =WORKDAY(DATE(<year>,<month>,0),1)
    Reply With QuoteRegister To Reply
  11. 05-28-2013, 01:42 PM #11
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    Can't be bothered reading back!
    Perhaps you need to post some sample data, so everyone is not guessing at what you require.
    Reply With QuoteRegister To Reply
  12. 05-28-2013, 01:55 PM #12
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    It's not necessary to 'round' the 'number of days' part in the workday function.
    The Workday function itself does it for you be default.

    As for the new question...

    =WORKDAY(DATE(A7,B7,0),1)

    A7 = Year #
    B7 = Month #
    Result is 1st working day of given month/year
    Reply With QuoteRegister To Reply
  13. 05-28-2013, 02:03 PM #13
    Legend Rubber
    Legend Rubber is offline
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    Book1.xlsxwell i am sorry to bother you... i dont exactly know where everyone got confused... but anyways i have attached a sample...
    Reply With QuoteRegister To Reply
  14. 05-28-2013, 02:04 PM #14
    Legend Rubber
    Legend Rubber is offline
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    @Jonmo1
    Thanks, that answers it perfectly.... ignore the last reply that was for Mr.UK.
    THanks to everyone.
    Reply With QuoteRegister To Reply
  15. 05-28-2013, 02:06 PM #15
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: i would like to do a future ship date using =TODAY()+x but i dont want weekends includ

    In C6 put
    =WORKDAY(DATE(J3,MONTH((1&J2)),0),1)
    In C7 and filled down
    =WORKDAY(C6,1)
    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)

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