Find the difference between to cells based on the value from the other cell

[HelloKhritty]

Hello,
So i do have a project where i want to get the difference between two cells. However it will be based on the date from the other cell.

as you can see in the table, The date on column B will be my basis. I need to find the diff of column E and column G based on the date given in column B, but my problem is, if the date in column D has no matched date in colunm F i need to have a 0.00 equals to the date that has no matched date to subtract it for column E and vice versa.
the formula i need is this:
in B column thers is 63022
D column there is no 63022 so the value will be 0.00 and will be less to G value which has the same date 63022.
and same goes to if both column have the same date as given in column B.
The difference will be placed in column I
I hope my problem is clear to understand and I hope you can help me. If You can have an excel formula for this then it will be very great, but if vba only, i would gladly accept it. thanks in advance. Really appreciate you guys in here.

 

[KRice]

I'm not sure which direction you want the difference (E-G or G-E), but this approach takes the date on a given row in column B and looks for a MATCH in columns D and F, and then returns the corresponding values in E and G. If a match is not found, this attempt to find a "match" will result in an error, so the IFERROR wrapping is used to return a 0 in that case. Then the difference is taken (E-G)...if you want G-E, then switch the order or change the sign of the result.

Book1
	B	C	D	E	F	G	H	I
1
2			Cside		Dside			Diff
3	SMS Posted Date		Date	Sum	Date	Sum
4	63022		60122	0.1	60322	10		0
5	62922		60322	0.2	62922	11		-11
6			50000	99	60122	12		0
7	40000							7.77
8	50000							97.67
9			40000	7.77				0
10					50000	1.33		0
Sheet2

Cell Formulas
Range	Formula
I4:I10	I4	=IFERROR(INDEX($E$4:$E$10,MATCH($B4,$D$4:$D$10,0)),0)-IFERROR(INDEX($G$4:$G$10,MATCH($B4,$F$4:$F$10,0)),0)

As a side note, it would be preferred if you would use the XL2BB add-in to provide a small mini-sheet of your worksheet rather than a picture. The mini-sheet can be readily copied into a worksheet, and that convenience improves the odds of getting a response.

 

[Peter_SSs]

Does this do what you want?

22 07 04.xlsm
	B	C	D	E	F	G	H	I
1
2			Cside		Dside			Diff
3	SMS Posted Date		Date	Sum	Date	Sum
4	63022		60122	0.1	60322	10		0
5	62922		60322	0.2	62922	11		-11
6			50000	99	60122	12		0
7	40000							7.77
8	50000							97.67
9			40000	7.77				0
10					50000	1.33		0
Diff on date

Cell Formulas
Range	Formula
I4:I10	I4	=SUMIF(D$4:D$10,B4,E$4:E$10)-SUMIF(F$4:F$10,B4,G$4:G$10)

Another side note. It is usually very helpful in clarifying your question if you include the expected results, manually entered with your sample data.