+ Reply to Thread
Results 1 to 7 of 7

WORKDAY Formula

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Surrrey
    MS-Off Ver
    Excel 2013
    Posts
    10

    WORKDAY Formula

    I have set up a simple spreadsheet to identify the numbers of days to deliver a product. Cell A2 contains a product. Cell B2 contains an order date. Cell C2 contains the formula =WORKDAY(B2,2). This works fine but what I would like to do is produce a dropdown menu in A2 to allow me to pick a product and for the formula in C2 to adjust according to the product

    Product date ordered delivery date
    Battery 02/06/2014 04/06/2014

    In the example above a battery takes 2 days to deliver but a torch might take 8 days to deliver. How can I get the C2 formula to adjust depending on product.

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: WORKDAY Formula

    hi ,

    provide a sample workbook,

    Punnam

  3. #3
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: WORKDAY Formula

    You could try creating a table for the item and how long for delivery, then use a vlookup to return the number of days.

    =WORKDAY(B2,VLOOKUP(A2,F1:G3,2,FALSE))

    B2 = Order Date
    A2 = Product

    A2:F1 = Lookup Table (Can be placed on a separate sheet and given a dynamic named range)

    Windy

  4. #4
    Registered User
    Join Date
    05-13-2013
    Location
    Surrrey
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: WORKDAY Formula

    I cant upload workbook as it contains customer information

  5. #5
    Registered User
    Join Date
    05-13-2013
    Location
    Surrrey
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: WORKDAY Formula

    I will give that a try. Think I know what you mean

  6. #6
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: WORKDAY Formula

    See attached.

    Sheet3 has alternate layout.

    Windy
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-13-2013
    Location
    Surrrey
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: WORKDAY Formula

    Quote Originally Posted by windy58 View Post
    See attached.

    Sheet3 has alternate layout.

    Windy
    That works perfectly many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Workday in formula
    By WiserGuy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2014, 11:30 AM
  2. Workday.INTL or Workday function issue
    By junoon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 03:14 PM
  3. Workday Formula
    By Blake 7 in forum Excel General
    Replies: 2
    Last Post: 02-14-2012, 05:19 AM
  4. Workday formula
    By 3daluminium in forum Excel General
    Replies: 5
    Last Post: 04-22-2010, 02:26 PM
  5. Workday Formula
    By Gos-C in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2005, 03:47 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1