This screenshot shows a worksheet containing a LAG/LEAD calculation.