Forum Discussion
ronnomad
Mar 13, 2019Copper Contributor
Dates as numbers in formulas?
I use a spreadsheet to calculate fuel cost/economy and usage over the course of the year. Individual columns show date (in date format), fuel cost, mileage, etc. Then by simple division or multipli...
Detlef_Lewin
Mar 13, 2019Silver Contributor
ronnomad wrote:However, if I write the formula using B152 (the cell in which 42370 is located) and B153 (the corresponding cell for 42736), I get a an answer of 0.00 or some other null answer.
Would you show us this formula?