In a table BMW Miles I have columns date, miles, gallons, cost, distance.

I want a formula to subtract previous.record.miles from current.record.miles and enter result in current.record.distance.

How would I do this?

Thanks in advance

MarkL