User-defined calendar planning
Backward Project Date Planner
Enter the stages in reverse order: the first record is the stage that ends on the target date, the next is the stage before it, and so on. Every duration comes from you and is counted in continuous calendar days.
Enter the target date → list stages from latest to earliest with your own durations → review the calculated dates. No delivery date is promised.
Enter your records
Required inputs must be complete. Enter 0 only when zero is deliberate; missing values remain unresolved. Use non-confidential references only.
Record fields
- Target date
- Stage (latest stage first)
- Duration in calendar days
- Basis for the duration / responsible party
Reviewable result
Enter records to begin.
Worksheet processing stays in this page. Inputs are not uploaded or stored, and reloading clears them. Page analytics are disabled here. Contact links and the quote form are separate actions; review the result before choosing to share it.
Worked example
An importer works back from a hotel opening date to see when each stage of a vanity order would need to start, using durations the team has assumed.
Example figures are invented for illustration. They are not product data, prices or a quotation.
Whole-worksheet settings
| Target date | 2027-03-15 |
|---|
Example inputs
| Stage (latest stage first) | Duration in calendar days | Basis for the duration / responsible party |
|---|---|---|
| Install and punch list | 14 | Site team estimate |
| Inland delivery to site | 5 | Assumed, carrier to confirm |
| Ocean freight and customs | 30 | Assumed, forwarder to confirm |
| Production | 55 | Assumed, supplier to confirm |
Result from the worksheet
Backward Project Date Planner LOCAL WORKSHEET — entered data only Install and punch list: 2027-03-01 → 2027-03-15 | 14 calendar days | Site team estimate Inland delivery to site: 2027-02-24 → 2027-03-01 | 5 calendar days | Assumed, carrier to confirm Ocean freight and customs: 2027-01-25 → 2027-02-24 | 30 calendar days | Assumed, forwarder to confirm Production: 2026-12-01 → 2027-01-25 | 55 calendar days | Assumed, supplier to confirm No product, inspection, installation, stock or delivery approval is generated.
How to read it
The last stage ends on the target date 2027-03-15 and starts 14 calendar days earlier, on 2027-03-01. That date becomes the end of the stage before it, and the chain continues back to a Production start of 2026-12-01. The dates only follow from the durations entered, which the basis column marks as assumed, so each still needs confirming by the party named.
How the dates are counted
The first stage ends on the target date and starts its number of calendar days earlier. That start date becomes the end of the stage before it, and so on down the list. Dates use UTC calendar arithmetic, so daylight-saving changes don’t shift them. A duration of 0 is accepted only when you enter it.
Not a working-day or logistics planner
Weekends, holidays and closures are not skipped. Parallel work, critical paths, sailings, port delays and customs clearance are not modeled. If they matter, settle the durations and dependencies elsewhere before entering a simple sequence.
A calculated date is not a promise
The tool holds no default WNS production time, freight time or buffer. Keep the basis for each duration and confirm it with whoever is responsible. Copying a timeline into an inquiry doesn’t reserve capacity or agree a delivery date.
User-defined calendar planning questions
Which stage goes first?
The stage that ends on the target date, followed by the stages before it.
Are weekends excluded?
No. Durations are continuous calendar days.
Why is the basis for each duration required?
It shows whether a duration is assumed or confirmed, and by whom.
Can two parallel stages be planned here?
No. The tool handles a single sequence only.
Does the earliest date confirm a WNS production slot?
No. Capacity and commercial dates need separate agreement.
Discuss the reviewed requirement
Use the result to identify questions for WNS Global. Offered products, specifications and commercial conditions still require separate confirmation.