How to plan a trip in a spreadsheet: dates, bookings, budget, packing
Short answer
Put the trip start date in one cell and calculate each day's date from it (start + day − 1), so changing the date moves the whole plan. Keep bookings with confirmation numbers in one table and compare planned budget with spending by category.
- Start date in one cell; Day N date = start + N − 1.
- One table for bookings with confirmation numbers and links.
- Budget by category vs actual spend.
- A packing list you can tick.
Copy-paste code
Spreadsheet: the date of day N (start date in B1, day number in A2)
=B1+A2-1Roamsprig Trip Planner + Packing List: Spend your trip on experiences, not logistics
from $9Roamsprig ($9) does this: set your dates once and every day of the itinerary gets its date, with bookings, budget and a packing list.
Secure checkout · 14-day fix-or-refund if it doesn't work as described (terms)Free: the Free Planner Sampler
4 printable previews (budget, debt payoff, focus planner, habit tracker), then 5 short emails with formulas that make a budget stick.