I need to create a mileage template that I can use for tax purposes for my real estate business. I’ve seen a couple posted. But, not all my mileage I do is for business purposes. So, I need to be able to track the specific work related mileage. Anybody have a good sheets template or recipe to make a good one?
Hi bdrum,
See if this works for you.
Column C contains Pop-Up Menus.
Enter Odometer Start in D2. You only need to do this in D2, because other starts are automatically entered:
Formula in D3: E2
Fill Down.
Enter Odometer Finish in column E.
Formula in F2: IF(E2="","",E2−D2)
That enters blank until the Odometer Finish is entered for that trip.
In the Summary table, formula in B2: SUMIF(Log::C,A2,Log::F)
Fill Down.
Please call back with questions.
Regards,
Ian.
Hi bdrum,
See if this works for you.
Column C contains Pop-Up Menus.
Enter Odometer Start in D2. You only need to do this in D2, because other starts are automatically entered:
Formula in D3: E2
Fill Down.
Enter Odometer Finish in column E.
Formula in F2: IF(E2="","",E2−D2)
That enters blank until the Odometer Finish is entered for that trip.
In the Summary table, formula in B2: SUMIF(Log::C,A2,Log::F)
Fill Down.
Please call back with questions.
Regards,
Ian.
Sounds like a good beginner project to learn how to create a spreadsheet.
Mileage Log Needed
