how long does wine last after opening

How long is wine good after opening? Red 3–5 days, light white and rosé 5–7, sparkling 1–3, Port 28. Plus how to spot bad wine and recork it.