Ravi Sir's Cards › Excel
Gas Cylinder Tracker in Excel (card 2 of 2)
Revision card 2 for Gas Cylinder Tracker in Excel: Shortest / longest: =MIN(D7:D12)&" / "&MAX(D7:D12)&" days" gives 32 / 37 days; Days the current one has been in use: =B3-B13 gives 20; Expected run-out date: =B13+ROUND(H7,0) gives 01-11-2026. Includes an example data table.
Read card text
What this card says
2 for Gas Cylinder Tracker in Excel: Shortest / longest: =MIN(D7:D12)&" / "&MAX(D7:D12)&" days" gives 32 / 37 days
Days the current one has been in use: =B3-B13 gives 20
Expected run-out date: =B13+ROUND(H7,0) gives 01-11-2026. Includes an
Example
data table
Learn this in the lesson: Gas Cylinder Tracker in Excel: How Many Days Each LPG Cylinder Lasts and When to Book the Next