# How to Create a Gas Mileage Calculator in Excel – 6 Steps

This is an overview.

### Step 1 – Enter the Date and the Odometer Reading

• Insert two columns: Date and Odometer Reading.
• Enter the dates and the odometer reading for each date.

### Step 2 – Calculate the Distance Traveled

• Insert the column Distance Traveled.
• Select D6 and enter the following formula.
=C6-C5
• Press Enter to get the distance traveled on 01-12-2022.

• AutoFill this formula to the rest of the cells in column D.

You will get the distance traveled for 7 days.

### Step 3 –Â  Enter the Consumed Fuel

• Insert the column Fuel Consumed.
• Enter the consumed fuel in gallons for each date.

### Step 4 – Determine the Gas Mileage

Determine gas mileage for 7 days in the Mileage column.

• Select F6 and use the following formula.
=D6/E6
• Press Enter.

• AutoFill the formula to see the Mileage.

### Step 5 – Calculate Cost Per Mile

• Enter the Fuel Cost per Gallon.

• Select G6 and use the formula below.
• Press Enter.
=E6*\$D\$14/D6

• AutoFill the formula to seeÂ the Cost per Mile.

### Step 6 – Calculate the Total Cost

• Select H6 and use the following formula.
=D6*G6
• Press Enter.

• AutoFill the formula to see the total cost for the 7 days.

Notes

<< Go Back to Excel Mileage Calculator | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Alif Bin Hussain

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF