My Expense Tracking app provides the ability to enter personal mileage. The user simply selects a customer code from a choice listing, enters the number of miles driven and the date upon which the mileage was driven.
Reimbursable mileage rates, per US Government rules, can change every year. The rate for 2020 was 57.5 cents per mile. This year it is 56 cents per mile. I have named mileage rate cells in a Parameters sheet. The rate of $0.575 is named MileageRate1. This year’s rate ($0.56) is named MileageRate2, etc.
I’d like to use If…Then logic to calculate the reimbursable dollar amount to the effect of: If ExpenseDate is greater than 12/31/20, use MileageRate2, otherwise MileageRate1. That way all 2020 entries will be preserved at the previous rate and this year’s amounts will also be accurate.
Suggestions on how to do this? Should it be done in the Google Sheet side or the Glide Data Editor?