+ Reply to Thread
Results 1 to 3 of 3

add 4 days to date/time

  1. #1
    brian thompson3001 via OfficeKB.com
    Guest

    add 4 days to date/time

    Hi

    Have had help with this, but still short of goal

    criterea
    1) Weekday anything after 1600 is classed as next day's date
    2) anything after 1600 on friday, classed as Monday
    3) sat and sun is classed as monday

    Need to add 4 days

    Examples

    fri 3/3 07:00:00 result should be 9/3
    fri 3/3 16:51:00 result should be 10/3
    sat 4/3 any time result should be 10/3
    sun 5/3 any time result should be 10/3
    Mon 6/3 00:51:00 result should be 10/3

    Any help, direction would be appriciated

    regards

    --
    bnt

    Message posted via http://www.officekb.com

  2. #2
    Bob Phillips
    Guest

    Re: add 4 days to date/time

    Sorry Brian, I thought I had responded to this

    =WORKDAY(A1,IF(OR(WEEKDAY(A1,2)>5,B1>TIME(16,0,0)),5,4))

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "brian thompson3001 via OfficeKB.com" <u15682@uwe> wrote in message
    news:5d0a48f44499b@uwe...
    > Hi
    >
    > Have had help with this, but still short of goal
    >
    > criterea
    > 1) Weekday anything after 1600 is classed as next day's date
    > 2) anything after 1600 on friday, classed as Monday
    > 3) sat and sun is classed as monday
    >
    > Need to add 4 days
    >
    > Examples
    >
    > fri 3/3 07:00:00 result should be 9/3
    > fri 3/3 16:51:00 result should be 10/3
    > sat 4/3 any time result should be 10/3
    > sun 5/3 any time result should be 10/3
    > Mon 6/3 00:51:00 result should be 10/3
    >
    > Any help, direction would be appriciated
    >
    > regards
    >
    > --
    > bnt
    >
    > Message posted via http://www.officekb.com




  3. #3
    brian thompson3001 via OfficeKB.com
    Guest

    Re: add 4 days to date/time

    thanks bob, this is exactly what i required....VBG

    regards



    Bob Phillips wrote:
    >Sorry Brian, I thought I had responded to this
    >
    >=WORKDAY(A1,IF(OR(WEEKDAY(A1,2)>5,B1>TIME(16,0,0)),5,4))
    >
    >> Hi
    >>

    >[quoted text clipped - 18 lines]
    >>
    >> regards


    --
    bnt

    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1