Results 1 to 14 of 14

Determine date based on request date meanwhile falls on particular days

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2019
    Posts
    74

    Determine date based on request date meanwhile falls on particular days

    I wish to use a formula to determine delivery date based on the request date meanwhile I need it to falls on particular days which allows delivery.
    I have been digging around the forum to find relevant formula but I failed to get any. Please advise if you have any suggestion. Thanks~*

    Example:

    Customer: ABC (Deliver on Thursday).
    Req Date: 28 Jun 2013
    Del Date: ? --> Outcome should be 27 Jun 2013 as I need the del date to be schedule before the req date & falls on Thurs.

    Customer: DEF (Deliver on Monday).
    Req Date: 28 Jun 2013
    Del Date: ? --> Outcome should be 24 Jun 2013 as I need the del date to be schedule before the req date & falls on Mon.I wish to use a formula to determine delivery date based on the request date meanwhile I need it to falls on particular days which allows delivery.
    I have been digging around the forum to find relevant formula but I failed to get any. Please advise if you have any suggestion. Thanks~*

    Example:

    Customer: ABC (Deliver on Thursday).
    Req Date: 28 Jun 2013
    Del Date: ? --
    Last edited by Hikari; 02-25-2013 at 08:53 PM.

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