Days between dates
BeginnerIn operations, “days to ship” is a simple but important metric. It helps you spot delays and track fulfillment speed.
In Excel, dates are stored as numbers. That means you can calculate the number of days between two dates by subtracting them, or by using the DAYS function.
What you need to do:
- Click cell D2.
- Calculate the number of days between the Order date in B2 and the Ship date in C2.
- Press Enter. You should see a number of days (like 0, 1, 2, etc.).
- Fill the formula down from D2 through D7 to calculate days to ship for every order.
Need some help?
Hint 1
You can get “days to ship” by subtracting the order date from the ship date. The result will be the number of days.
Hint 2
If you want a function, use DAYS. It takes two dates: the end date first, then the start date.
Hint 3
If your result is negative, swap the date order so the later date (ship date) is first and the earlier date (order date) is second.
Related function(s)
Days between dates
BeginnerIn operations, “days to ship” is a simple but important metric. It helps you spot delays and track fulfillment speed.
In Excel, dates are stored as numbers. That means you can calculate the number of days between two dates by subtracting them, or by using the DAYS function.
What you need to do:
- Click cell D2.
- Calculate the number of days between the Order date in B2 and the Ship date in C2.
- Press Enter. You should see a number of days (like 0, 1, 2, etc.).
- Fill the formula down from D2 through D7 to calculate days to ship for every order.
Need some help?
Hint 1
You can get “days to ship” by subtracting the order date from the ship date. The result will be the number of days.
Hint 2
If you want a function, use DAYS. It takes two dates: the end date first, then the start date.
Hint 3
If your result is negative, swap the date order so the later date (ship date) is first and the earlier date (order date) is second.