Delivery date accuracy

A

Antoan

New Member
Joined
Nov 29, 2021
Messages
26
Office Version
  1. 2016
Platform
  1. Windows
Hello guys!


I have to compare the date of the delivery inhouse with shipment date(outbound) and therefore evaluate the delivery accuracy between those two types of date. In the beginning I tought that a pivot table would only be needed in order to make such kind of analysis, but I further in the process I got a bit lost...

Sorry for the simple question, but I'm not an expert in excel!

Your help would be much appeciated! :)

Gasa Data Consolidated new!.xlsx
ABCDEFGHIJKLMNOPQRSTUVWX
1Request IDDate for Delivery InhouseYear MonthWeek WeekdayQuarterShipment dateYear 2Month 2Week 2Weekday 2Vendor No.Item No.Item category No.DescriptionSell-to CustomerShip-to CodeShip-to CountrySales QuantityPcs/colliSales Quantity (Base)Quantity ShippedException lines
274367511/10/20202020114632020,411/10/20202020114631996110005543622Monstera deliciosa 103697SE4065-260040No
374367910/6/20202020104132020,410/6/20202020104131560010008396222Monstera deliciosa103697SE4062-248040No
475293112/28/20192019125272019,412/15/20202020125131995310009158018Catalogue103810NO51-55No
575293112/28/20192019125272019,412/15/20202020125131557110009155218Catalogue103810NO51-55No
675293112/28/20192019125272019,412/15/20202020125131995310009158018Catalogue103810NO101-1010No
775293112/28/20192019125272019,412/15/20202020125131952310009158318Catalogue103810NO11-11No
875293112/28/20192019125272019,412/15/20202020125131749910009158818Catalogue103810NO31-33No
975293112/28/20192019125272019,412/15/20202020125131904910009160518Catalogue103810NO11-11No
1075293112/28/20192019125272019,412/15/20202020125131996110009155018Catalogue103810NO11-11No
1175293112/28/20192019125272019,412/15/20202020125131996110009155018Catalogue103810NO51-55No
1275293112/28/20192019125272019,412/15/20202020125139999010009161318Catalogue103810NO81-88No
1375600411/2/20202020114522020,411/2/20202020114521788410005048805Cedrus Deodara1043490001DK251-2525No
147664639/16/2020202093842020,39/16/2020202093841987610007722523Dionaea muscipula104142DK212103-21836212No
1576646410/2/20202020104062020,410/2/20202020104061987610007722523Dionaea muscipula104142DK350103-36050350No
1676646611/26/20202020114852020,411/26/20202020114851987610007722523Dionaea muscipula104142DK350103-36050350No
177681932/18/202120212852021,12/18/202120212851953610011027541Hydrangea macrophylla104188FI540-2005No
187681932/18/202120212852021,12/18/202120212851953610011027641Hydrangea macrophylla104188FI640-2406No
197681932/18/202120212852021,12/18/202120212851953610010401141Hydrangea paniculata104188FI440-1604No
207681932/18/202120212852021,12/18/202120212851953610010187541Hydrangea macrophylla104188FI340-1203No
217681932/18/202120212852021,12/18/202120212851953610009509841Hydrangea macrophylla104188FI140-401No
227681932/18/202120212852021,12/18/202120212851953610007247441Hydrangea macrophylla104188FI440-1604No
Data
Cell Formulas
RangeFormula
C2:C22C2=YEAR([@[Date for Delivery Inhouse]])
D2:D22D2=MONTH([@[Date for Delivery Inhouse]])
E2:E22E2=WEEKNUM([@[Date for Delivery Inhouse]],1)
F2:F22F2=WEEKDAY([@[Date for Delivery Inhouse]],1)
G2:G22G2=CONCATENATE(YEAR([@[Date for Delivery Inhouse]]),",",ROUNDUP(MONTH([@[Date for Delivery Inhouse]])/3,0))
I2:I22I2=YEAR([@[Shipment date]])
J2:J22J2=MONTH([@[Shipment date]])
K2:K22K2=WEEKNUM([@[Shipment date]],1)
L2:L22L2=WEEKDAY([@[Shipment date]],1)
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
You could create a new column and use a simple math formula such as =B2-H2 and format the resulting cell as a number. This will give you the number of days between the two dates.
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

A
  • Question
Fetch heads up stats between 2 teams
Replies
2
Views
119
AYouQueTai
A
A
  • Solved
Countifs? Count events in a range if something doesn't happen in another range
Replies
2
Views
156
AYouQueTai
A
F
  • Solved
Dynamic Array Formula Problem
Replies
5
Views
121
KRice
K
K
  • Question
Help with difference between 2 dates including am/pm and check multiple entries to see if they occur at the same date and am/pm
Replies
1
Views
156
XLfriend777
XLfriend777
JenniferMurphy
  • Solved
Adding a new time causes wrong average
Replies
3
Views
123
awoohaw
awoohaw

Forum statistics

Threads
1,214,887
Messages
6,122,095
Members
449,064
Latest member
Danger_SF

Share this page

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