I have an excel table that has a list of measurements and dates those measurements were taken. Each measurement is from a specific location. I need to perform a series of calculations that are based on the previous date. In the attached, the columns I need help with are in bold:
Amt_Used: Amount in date "x" from location "a" - amount in preceding date from location "a"
Time_Diff: Number of days between date "x" and preceding date.
Per_Day_Use: Amt_Used / Time_Diff
Remaining_Days: Amount from date "x" / Per_Day_Use
Date_Empty: Date "x" + remaining days