Splitting date ranges across months in a spreadsheet, with no macros (a booking-ledger example)

Note: The Porchlight Ledger spreadsheet is no longer available; this guide is kept for reference. Written by Porchlight Ledger with AI assistance and checked by hand in Excel, Google Sheets and LibreO