on-time

  1. A

    Formula to Return Training Status with Multiple Outputs

    I a table with 6 different input scenarios and need to return 4 different outputs depending on the input. The table data is all dates and I would like to fill the Status column with one of the following outputs. No-Value Complete On-Time Past-Due An example of the scenarios in the table...
  2. A

    On-Time calculations - using only workdays?

    All, I need to calculate whether a production item is On-Time (early or on-time), or Late, using workdays only to calc. I also want to be able to get a summary or total by month or similar. I have the following set up already: Deadline Date Actual Production Date If Actual is earlier or same as...
  3. E

    copying sheets and changing date information on them

    <tbody> Day Total Orders Total Late % Late % on-time February 1, 2018 February 2, 2018 February 3, 2018 Average on-time % #DIV/0! </tbody> I use a table similar to this each month (entire date range of the month) to calculate our companies on-time delivery percentage. I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top