Formulas for tank volume calculation by using DATE

[billybarty]

I need to make a sheet that will let me know the volume in a container by using the date and i don't know how to proceed. I have columns with the date the container was last filled and the volume on that day, a column for the rate of consumption per day, a column for what is the volume today, a column for what the volume will be in x number of days (currently 7) and a column for the date that the volume will be 40 liters or less. I had tried this before at my previous job and had some help with this on this forum but am unable to find the post. Also, I am using Excel 2003 at this position and it doesn't have as much built-in help on building formulas. Any help is appreciated

 

[shg]

Dunno. Put the workbook on box.net and post a link.

 

[billybarty]

https://app.box.com/files/0/f/0/1/f_16688056721

 

[MarkAMcCain]

Silly question. For the formula in I2 are you putting:

I2: =G2 - (TODAY() - F2) * H2

In the cell or

=G2 - (TODAY() - F2) * H2

The first will give you an #value error, the second will work.

 

[shg]

Your file is not accessible. You need to click Share and then paste the link that appears.

Mark makes a good point.

 

[billybarty]

I am putting =G2 - (TODAY() - F2) * H2.
https://app.box.com/s/7n6llg6xp3pwk8uaxwc6

 

[shg]

Formulas look fine to me, both in the box preview and when downloaded.

 

[billybarty]

https://app.box.com/s/n0okbqev30o3h9i9c4yc this is what I get when I evaluate the error in I2. Looks like its reading one of the dates as a number

 

[billybarty]

https://app.box.com/s/7d6yie74c3p0rcae5kqi is the evaluation when I look at the error in K2

 

[FormR]

Re-enter the date in F2 in your locale format. i.e. instead of 04/28/14 re-enter as 28/04/14.

 

[billybarty]

That got it, thanks for all your help. Much appreciated