Excel: Formulas for tank volume calculation by using DATE

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

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of April 28, 2014.

For more resources for Microsoft Excel