This screenshot shows a worksheet containing a LAG/LEAD calculation used to compare sales with a previous year's figures.