Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weekend formula (2000/SP3)

    Hello, I am not a very advanced user and am trying to do the following:

    IF (H4+4 = Saturday, add 2 (H4+6) if H4+4=Sunday, H4+5)
    If H4+4= a Holiday, return the next workday, otherwise just add H4+4

    So really what I am trying to accomplish is adding 4 days onto the date in cell H4, but the result has to land on a weekday. I have my sheet of holidays, and that weekday formula works on all the other processes, except this one. The weekday formula doesn't work because it takes out the weekends altogether and adds too many days. I have parts that have to come out of a process that takes 5 days, inclusive of the first and last. There is no one here to take them out on a Saturday or Sunday, or a Holiday but those days are counted as part of the time they are in the process.

    I'm not sure if my explanation makes any sense, but thanks in advance.

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weekend formula (2000/SP3)

    In Excel 97's Analysis Toolpak, there's a function called WORKDAY. If you put 4 into the second argument, I think you will get exactly what you need.

Posting Permissions

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