How to track skincare products' period after opening (PAO)
Short answer
Many cosmetics show a period-after-opening (PAO) symbol: an open jar with a number of months, such as 12M. Write down the date you opened each product; its use-by date is that date plus the PAO months. Cost per day is the price divided by the days it lasts.
- Find the PAO symbol (e.g. 6M, 12M) on each product.
- Log the open date.
- Use-by = open date + PAO months (EDATE in a spreadsheet).
- Cost per day = price ÷ days until empty or expired.
Copy-paste code
Spreadsheet: use-by date from the open date (B2) and PAO months (C2)
=EDATE(B2, C2)Good to know
General organising tool; not medical or dermatological advice.
Dewsprig Self-Care & Skincare Routine Tracker: A skincare routine you actually keep
from $9Dewsprig ($9) builds your AM and PM routine from your own shelf, shows each product's expiry after opening and cost per day, and lets you tick your routine.
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.