Level 1

12 points

Mileage Log Needed

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?

Posted on Jul 24, 2023 9:55 AM

Reply

Similar questions

how can I see a summary of a particular activity, i.e. how many miles I cycled this month how can I see a summary of a particular activity, i.e. how many miles I cycled this month?
282 1
Activity App How do I get a summary of my running mileage for the year, or even the month?
787 2
Where is the mileage graph/mileage legend located in the maps that "Find My" uses? When I use "Find My" to locate a friend, the map that comes up does not have any kind of a mileage indicator available that I can find. On any normal mapping software, there is usually a legend that tells you that, for example, 1 inches equals 50 miles, or whatever. Why doesn't Apple have enough common sense to include this basic feature in its software? If it is there, my apologies and WHERE THE HE** IS IT?????? And if it does exist, why is it so damned hard to locate? By the way, Google maps offers this basic feature. So does literally every other mapping program available on the internet today.
287 5

2 replies

Level 7

24,910 points

Jul 24, 2023 10:26 AM in response to bdrum99

Sounds like a good beginner project to learn how to create a spreadsheet.

Reply

Level 6

19,992 points

Jul 25, 2023 6:59 PM in response to bdrum99

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.

Reply

Mileage Log Needed

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up