The number of miles a vehicle can travel using a certain amount of gas or fuel is known as gas mileage. A vehicle user might want to keep track of the vehicle running costs that he is spending. For that, he will need to know the mileage of each day of his vehicle. In this article, we will walk you through six easy steps to **create a gas mileage calculator in Excel**. Here’s an overview of the gas mileage calculator we have prepared for this article.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook to exercise while reading this article.

## Step-by-Step Procedures to Create Gas Mileage Calculator in Excel

In this article, we will demonstrate six steps to **create a gas mileage calculator in Excel**. The steps are described in detail with proper illustrations in the following section.

### Step 1: Insert Date and Odometer Reading

In the first step, we will need the odometer reading from a vehicle. We will use this reading as input.

- First of all, Insert two columns and name them
**Date**and**Odometer Reading**. - Then write the dates and odometer reading of each date as input in the columns.

**Read More: How to Make Vehicle Life Cycle Cost Analysis Spreadsheet in Excel**

### Step 2: Calculate the Distance Traveled

We will now calculate the distance traveled by the vehicle on each date.

- First, add a column named
**Distance Traveled**. - Then select cell
**D6**and write down the following formula.

`=C6-C5`

- Afterward, press
**Enter**to get the**distance traveled**on**01-12-2022**.

- After that,
**AutoFill**this formula to the rest of the cells of column**D**. - Hence, you will get the value of
**distance traveled**for all 7 days.

### Step 3: Insert Fuel Consumed

In this step, we will need the amount of fuel consumed on each date.

- First, insert a column and name it
**Fuel Consumed**. - Then input consumed fuel in gallons for each date.

**Read More: How to Make Daily Vehicle Mileage and Fuel Report in Excel**

### Step 4: Determine Gas Mileage

In this step, we will determine gas mileage for all 7 days in the **Mileage **column.

- First of all, select cell
**F6**and type the following formula.

`=D6/E6`

- Then Hit
**Enter**.

- Finally,
**AutoFill**this formula and you will have the**Mileage**for all the dates.

**Read More: How to Calculate Mileage Reimbursement in Excel (Step-by-Step Guide)**

### Step 5: Calculate Cost Per Mile

Now we will calculate the cost per mile driven by the vehicle. For that, we need the value of **Fuel Cost per Gallon**.

- First of all, insert the value of
**Fuel Cost per Gallon**.

- Next, select cell
**G6**and write the formula given below, and press**Enter**.

`=E6*$D$14/D6`

- Then
**AutoFill**this formula to the rest of column**G**to determine the**Cost per Mile**of each date.

**Read More: How to Calculate Mileage in Excel (Step-by-Step Guide)**

### Step 6: Compute Total Cost

In the final step, we will calculate the total cost for the distance traveled on each day.

- First, select cell
**H6**and type the following formula.

`=D6*G6`

- Further, hit the
**Enter**button on your keyboard.

- Finally,
**AutoFill**this formula to the rest of the cells and you will get the total vehicle running cost for all 7 days.

__Notes__- Don’t forget to give proper
**cell references**or you won’t get your desired result. - You can change the units of distance and fuel as per your need.

## Conclusion

Thanks for making it this far. I hope you find this article useful. Now you know six easy steps to **create a gas mileage calculator in Excel**. Please let us know if you have any further queries, and feel free to give us any recommendations in the comment section below.