Calculating amount between yesterday and the day before.

[Joeclupis]

I have a workbook with several spreadsheets that have a column that we track a physical inventory in a fuel tank. I am trying to come up with a formula that will point to the correct column (Column L), use the number from yesterday and subtract the number from the 'day before yesterday'. I tried using TODAY(). Evidently I was incorrect and looking on the web didnt bring any joy. I am using 'yesterday' and 'day before yesterday' as descriptors for the cell locations.

I have my date column in Column A.

The sheet with the information that the data is on is called DAILY VALUES. And I would like to put the resulting number from the calculation on a sheet called DASHBOARD.

Thank you for your help.

 

[mart37]

yesterday = today()-1

 

[Joeclupis]

yesterday = today()-1

that I understand, but how do I get excel to subtract a number in a column that the row is the day before yesterday from a number in the same column where the row is yesterday? I am not trying to subtract dates/days, i am trying subtract numbers cooresponding to the last two days to get a continuously updating sum.

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	L
1	-10
2
3		25-Oct-17				100
4		26-Oct-17				80
5		27-Oct-17				70
6		28-Oct-17				50
7
DAILY VALUES

Cell Formulas
Range	Formula
A1	=INDEX('DAILY VALUES'!L:L,MATCH(TODAY(),'DAILY VALUES'!B:B,0)-1)-INDEX('DAILY VALUES'!L:L,MATCH(TODAY(),'DAILY VALUES'!B:B,0)-2)