Delivery Schedule Excel: Create and Manage a Delivery Plan

How-to basics · Updated November 22, 2026

A delivery schedule in Excel is a workbook that records each shipment, its planned delivery date, its actual arrival, and its current status. Start with one row per delivery and columns for an ID, recipient, destination, carrier, dispatch date, transit time, planned date, actual date, and status; then use Excel formulas, filters, and formatting to keep the list useful as it grows.

What a delivery schedule is used for

A delivery schedule turns scattered shipment details into a shared planning view. A small business might use it to coordinate customer orders, while a warehouse team might use a similar sheet to track inbound stock or transfers between locations. It can show what is due today, what is at risk of arriving late, and which deliveries need follow-up.

Excel is a practical choice when a team needs a flexible table and does not need a dedicated transport-management system. It can sort, filter, calculate working-day dates, and summarize a modest list. It does not automatically know where a driver or parcel is: unless the workbook is connected to another system, someone must enter or import current tracking information.

Decide what the schedule is meant to answer before adding columns. A customer-facing promise date, an internal warehouse arrival plan, and a driver route sheet have different needs. Trying to make one tab serve all three can produce a cluttered workbook and unclear ownership.

Choose fields that support the workflow

In Excel for Microsoft 365 on Windows, put descriptive headers in row 1 and enter one delivery per row beneath them. A useful basic layout is:

  • Delivery ID: a unique order or shipment reference. Avoid relying on row numbers, which change when records are sorted.
  • Recipient and destination: enough detail to identify who or where the delivery is for. Restrict sensitive personal details to what the team actually needs.
  • Carrier or assigned driver: the responsible service or person.
  • Dispatch date and transit time: the date the shipment leaves and, if known, the expected number of working days in transit.
  • Planned delivery and actual delivery: keep the promise or forecast separate from the recorded arrival.
  • Status and notes: a concise stage such as Scheduled, In transit, Delivered, or Exception, plus a short explanation when action is required.

Use consistent date values rather than typing dates as text. For example, a cell containing a true Excel date can be sorted chronologically and used in calculations; text that only looks like a date may not behave as expected. Apply a date display format from Home > Number Format, and choose a format that is unambiguous for everyone who will read the file.

One row per shipment is a helpful rule, but define what counts as a shipment. If a single order can arrive in several parcels, either assign a separate delivery ID to each parcel or add a package identifier. Otherwise, one status field may incorrectly imply that every part of the order has arrived.

Build the workbook and make it easier to use

Enter the headers, select the range, and choose Insert > Table. Confirm that My table has headers is selected. A table expands as you add records, carries formatting and formulas into new rows, and provides filter buttons on the headings. Give the table a clear name in the Table Design tab, such as Deliveries, if you plan to refer to it in formulas.

Keep the entry area simple. Use one value per cell, avoid merged cells inside the table, and do not insert blank rows between deliveries. Put instructions, a legend, and any holiday list outside the table or on a separate worksheet. If several people edit the workbook, agree on who owns updates and how frequently the schedule is refreshed.

To keep the column headings visible while scrolling, select cell A2 and choose View > Freeze Panes > Freeze Panes. This freezes row 1 while leaving the data area scrollable. In Excel for Mac, the View tab also contains Freeze Panes; the precise ribbon layout can vary by version. Excel for the web has a View tab as well, though some ribbon controls may be arranged differently.

Use filters on the table to show, for example, only deliveries for one carrier or shipments with a particular status. Sort the planned delivery column from oldest to newest to see the next items due. Avoid sorting just one column by itself, which can separate dates from their shipment records; sort using the table’s heading controls so whole rows stay together.

Calculate planned dates with working days

When a carrier estimate is expressed in working days, WORKDAY can calculate a planned date while excluding Saturdays and Sundays. Suppose dispatch dates are in E2, transit workdays are in F2, and the planned delivery date is in G2. With a dispatch date of June 3, 2026, and three transit workdays, the formula below returns June 8, 2026: Thursday, June 4, Friday, June 5, and Monday, June 8 are the three counted workdays.

With the dispatch date in E2 and the transit-day count in F2, enter =WORKDAY(E2,F2) in G2. For the example values above, the result is June 8, 2026. Excel table formulas typically fill down automatically when entered in a calculated column.

WORKDAY excludes weekends, but the basic formula does not exclude public holidays. If the business has a maintained holiday list on a worksheet named Holidays in A2:A20, use that list as the optional third argument: =WORKDAY(E2,F2,Holidays!$A$2:$A$20). With the same example and no holiday in that range, the result remains June 8, 2026. Enter genuine date values in the holiday list; text labels will not act as dates.

Transit estimates are not guarantees. If the carrier quotes calendar days rather than working days, WORKDAY may not represent the quote correctly. Confirm what the carrier’s estimate means and whether the dispatch day counts before choosing a calculation. You can also type a planned date manually when estimates depend on route, service level, cut-off time, or other rules that are not represented in the sheet.

Track status and flag late deliveries

Choose a short, agreed status list so different editors do not enter variations such as In transit, On the way, and Shipped for the same stage. A simple set might be Scheduled, In transit, Delivered, and Exception. Add an Exception note that tells the next person what needs checking, rather than using a vague note such as Problem.

For a drop-down list, select the status cells and choose Data > Data Validation. Set Allow to List and enter the permitted values in Source, separated by commas, such as Scheduled,In transit,Delivered,Exception. This reduces inconsistent entries. If the list is likely to change or needs to be reused, place the options in a small range on a separate sheet and use that range as the source. Excel for Mac includes Data Validation, though the dialog layout may differ; Excel for the web supports common validation tasks but may not expose every desktop option.

A formula can provide a basic status from the actual date and the planned date. Assume G2 contains the planned date, H2 contains the actual delivery date, and I2 is the status. With no actual date entered, the formula returns Late if the planned date is before today and Scheduled otherwise; if H2 has a date, it returns Delivered. For example, if evaluated on June 4, 2026, with G2 set to June 8, 2026 and H2 blank, it returns Scheduled.

With planned date in G2 and actual date in H2, enter =IF(H2<>"","Delivered",IF(G2<TODAY(),"Late","Scheduled")) in I2. The example result on June 4, 2026 is Scheduled. TODAY updates when Excel recalculates, so a status can change as time passes. This formula also treats a delivery due today as Scheduled, not Late; adjust the rule if the business defines the cut-off differently. It is a simple date-based indicator, not a live carrier status.

For visual emphasis, select the planned-date cells and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than. A rule based on a fixed date is easy to understand but needs updating. For a dynamic rule that depends on status, apply conditional formatting to the status column or use a formula-based rule, taking care to match the reference to the first data row. Use color as a cue, not as the only indicator; retain readable status text for printing and for readers who cannot distinguish the colors.

Summarize the schedule without hiding details

A summary can show how many deliveries are complete, but it should not replace the shipment-level list. For example, put total deliveries in one cell and completed deliveries in another, then calculate a completion share. Assume IDs are in A2:A101, statuses are in I2:I101, and every active delivery has an ID. With three IDs present and one status marked Delivered, the formula returns 33.33% when the result cell is formatted as a percentage.

With IDs in A2:A101 and statuses in I2:I101, enter =COUNTIF(I2:I101,"Delivered")/COUNTA(A2:A101) in the summary cell. In the example, one divided by three is 0.3333, displayed as 33.33%. If the schedule has no IDs yet, the denominator is zero and Excel returns a division error; use a blank or a separate message until records exist, or build an error check into the summary.

Other useful summaries include deliveries due today, counts by carrier, and exceptions needing attention. A PivotTable can group records by carrier or status without changing the source rows: select a cell in the table and choose Insert > PivotTable. Keep the source data consistent and refresh the PivotTable after changes if it does not update automatically in your setup.

Common mistakes and practical safeguards

Most schedule problems come from inconsistent data or unclear rules rather than complicated formulas. Watch for these issues:

  • Overwriting the promise date: retain the original planned date and record revised dates separately if you need to explain changes.
  • Mixing date types: standardize entry and display formats, and check that imported dates are recognized as dates.
  • Unclear status ownership: decide who updates the status and what evidence is enough to mark a delivery complete.
  • Duplicate shipment IDs: use a unique reference and periodically check for duplicates, especially after importing records.
  • Silent formula errors: test formulas on a few known examples and check blank, overdue, and completed cases before filling them down.
  • Uncontrolled edits: use appropriate workbook permissions and keep a protected backup when the schedule is operationally important.

Do not assume that a red cell proves a shipment is late or that a green cell proves delivery. Formatting rules can be misconfigured, and a date may be wrong. Check the underlying value and the carrier’s current information before taking action. If the workbook contains customer addresses or contact details, share it only with people who need access and follow the organization’s retention and privacy practices.

Excel schedule versus a template or delivery system

A blank workbook gives the most control, while a prebuilt template can save setup time. Templates vary, so inspect their columns, formulas, and assumptions before entering live data. A template that assumes calendar days or one package per order may not fit a workflow based on working days or split shipments. Keep a clean copy before changing a template you intend to reuse.

Excel is suitable for a straightforward schedule with a manageable number of editors and manual or periodically imported updates. It becomes less suitable when staff need simultaneous operational dispatching, automatic carrier tracking, route optimization, customer notifications, or robust access controls. A shipping platform, order-management system, or transport-management system may provide those features, depending on the product and integrations. A spreadsheet can still be useful for reporting or a limited planning task, but it should not be presented as a substitute for live tracking.

Before choosing, compare the time spent maintaining the sheet with the consequences of an inaccurate schedule. Consider how many users edit it, whether status updates arrive automatically, how much history must be retained, and whether records need to connect to orders or inventory. Start with the simplest approach that meets the real workflow, then revisit the choice when manual maintenance creates repeated delays or errors.

Frequently Asked Questions

How do I make a delivery schedule in Excel?
Enter one shipment per row, add columns for the delivery ID, destination, carrier, dispatch date, planned date, actual date, and status, then format the range as a table with Insert > Table. Add filters and a consistent status list before sharing it.

Can Excel calculate a delivery date automatically?
Yes, when the timing rule is known. WORKDAY can add a number of working days to a dispatch date and can exclude dates in a holiday list. Check whether the carrier’s estimate uses working days or calendar days before relying on the result.

How can I highlight late deliveries?
You can apply conditional formatting to dates or statuses using Home > Conditional Formatting. A date-based rule needs a clear definition of late, and a formula using TODAY changes as the current date changes. Verify the shipment information before acting on a highlight.

Should each order have one row?
Use one row per unit you need to track independently. If one order can arrive in separate parcels with different tracking numbers or dates, record each parcel separately or include a package identifier so the schedule does not mark the whole order delivered too early.

Is an Excel delivery schedule live tracking?
No. Excel calculates and organizes information that is entered or imported; it does not automatically locate a shipment. Live tracking requires carrier data or a connected service that supplies updates.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.