arrival

I have this formula that I've got working IF the sheet "Arrival" already exists. However, would would I go about using this if Arrival doesn't exist? I know how I could create it with vba but trying to figure out how to do it with a formula. Thanks

I am trying to build a formula in excel that will compare two dates. I am using =NETWORKDAYS formula to calculate the number of days in between, and that is working great. My problem is, in Cell C1, I am entering a date of arrival. What I need is: If the arrival date is a workday, then it...

Hello, I need to calculate how many minutes early/late a train arrived. I am comparing the scheduled train arrival, versus the actual train arrival. I have tried many formulas, but can't find a formula that works for all five scenarios I've encountered in my data below. Please note I must use...

Hello, I need to calculate how minutes late/early a train arrived (elapsed time) by comparing the scheduled arrival time with the actual arrival time. I have tried many different ways of doing this, but none of the ways seem to work for all four scenarios I've encountered with the data. Please...

I have looked and tried, and no luck. I need A3 to do 2 things When the arrival date is less than the number of days allowed to turn red. so it will turn red when a date is entered and also turn red automatically using today's date. A1 has arrival date A2 Has drop down list with 1 day, 3...

Hi there, First time post on this forum. Looking for some help with the following... I have two separate columns with varying times. The first column contains an arrival time and second column with a completion time. I need the second column completion time to automatically highlight once...

Good Afternoon- I'm trying to figure a code to go through the following processes: I'd like to open Excel- Initial sheet is the Master Template- 1. A dialog box opens with a series of inputs (They establish the "constants" in the formulas) 2. Then Either Sheet 1 "Noon" or the Totals...

Ok I've got (what I consider to be) a challenge problem. I have a workbook with 11 worksheets that are used (there are more but not printed). FYI- I have a I was wondering if someone could write a macro code, or series of codes, that with the ActiveCommand buttons I've put in: "Noon" -...

Before we start, I know I can do this via vlookup but it is massively time consuming. You'll see why. The goal: to figure out when my product will arrive at my assembly centers. The issue: I have a spreadsheet from my freight forwarder. It looks like this: <tbody> PO SKU QTY Depart Date...

Hi, Sheet 1 (Named as Imports): <tbody> Column A ........ ........ ........ ...... Column G Material name Arrival date </tbody> Sheet 2 (Named as To dos): Column D I need Name of materials (arriving within in next 30 days) with their arrival date in column D of sheet 2...

Hello everyone, How I can get: 1. case: arrival and departire date useing criterion 1 and date above AND In the other direction 2. case: need to get 1 in table using dates left and above? thank you very much :) <tbody> arrival departure 17.11.2017 18.11.2017 19.11.2017 20.11.2017...

I know this is easier than I'm making it, but I can't figure out how to to a vlookup with multiple criteria, or maybe using index match? On worksheet 1(let's say colum A). I have Item numbers, then a column for preship score and a column for arrival score. On worksheet 2 in column A i have item...