Formula Help

[excelbrands]

I am trying to compare dates between 2 different worksheets in the same workbook and summarize differences on summary worksheet. First I would need to search by ID number to make sure I am looking for the correct line, than look at the close date, compare this to the other worksheet using same ID number and see if the date changed. If it did, by how much? If no change than don't include in summary. I know there are a lot of steps and watched a ton of videos and am so confused. See attached

 

[AhoyNC]

If your ver. of 365 has the FILTER function then try:

Summary Sheet

Book1
	A	B	C	D
1	ID	Acct	Close Date	Reg
2	12545	Comcast	3/25/2019	E
3	12546	Vitafusion	2/19/2019	W
4	12547	Shutterfly	2/20/2019	C
5	12548	Stitch Fix	1/15/2019	E
Summary

Cell Formulas
Range	Formula
A2	A2	=SORT(FILTER('Quarter 1'!$A$2:$D$6,'Quarter 1'!$C$2:$C$6<>'Quarter 2'!$C$2:$C$6))

Quarter 1

Book1
	A	B	C	D
1	ID	Acct	Close Date	Reg
2	12545	Comcast	3/25/2019	E
3	12546	Vitafusion	2/19/2019	W
4	12547	Shutterfly	2/20/2019	C
5	12548	Stitch Fix	1/15/2019	E
6	12549	Apple	2/1/2019	W
Quarter 1

Quarter 2

Book1
	A	B	C	D
1	ID	Acct	Close Date	Reg
2	12547	Shutterfly	5/25/2019	C
3	12546	Vitafusion	4/3/2019	W
4	12548	Stitch Fix	6/25/2019	E
5	12545	Comcast	4/5/2019	E
6	12549	Apple	2/1/2019	W
Quarter 2