+ Reply to Thread
Results 1 to 11 of 11

Production and Delivery Formula

Hybrid View

  1. #1
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Need a Formula or spreadsheet

    Since I'm assuming you don't already have a worksheet available to work on, I attached an example that could be a possibility. Note that there are named ranges and data validation lists being used on the second sheet.

    Cells C2:C4 are variable. You pick the first two from a dropdown, and enter the "Called On" date in the third cell, and cell C6 calculates the day that it is due (taking into account non-working weekends only). The formula has been made scalable by referencing data on sheet 2, so if your delivery dates or build day times ever change, you can alter them on the second sheet's tables and the formula on sheet 1 will automatically update.

    Hope something like this helps!
    Attached Files Attached Files
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  2. #2
    Registered User
    Join Date
    01-09-2015
    Location
    manchester
    MS-Off Ver
    2010
    Posts
    9

    Re: Need a Formula or spreadsheet

    This is brilliant thanks for the quick response, but apologies I forgot to mention that we don't deliver on weekends, also is it possible to add days where the production might be closed as it will add a day on to the delivery date. like a box where I can enter a set number of days we will be closed on a weekday.

+ 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. Replies: 2
    Last Post: 03-27-2013, 03:55 AM
  2. [SOLVED] Formula in spreadsheet HELP PLEASE
    By Ncapanna in forum Excel General
    Replies: 1
    Last Post: 05-07-2012, 05:12 AM
  3. Using the same formula throughout the spreadsheet.
    By Brandon13830 in forum Excel General
    Replies: 2
    Last Post: 08-03-2006, 02:42 AM
  4. Replies: 1
    Last Post: 02-08-2005, 06:06 AM
  5. [SOLVED] How to use same formula throughout the spreadsheet??
    By whiteteeth in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-03-2005, 11:06 AM

Tags for this Thread

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