How to Find days between Submit Date by Manager

[brlattim]

How do I calculate the days between submissions by manager in the below example?

Customer Submit Date Manager
236104 7/2/2013 Jackson
236166 7/19/2013 Andrews
248058 9/30/2013 Smith
248058 9/30/2013 Smith
80313 9/30/2013 Thompson
80313 9/30/2013 Thompson
80313 9/30/2013 Thompson
251285 9/30/2013 Andrews
251285 9/30/2013 Andrews
251285 9/30/2013 Andrews
251285 9/30/2013 Andrews
251285 9/30/2013 Andrews
236166 7/19/2013 Andrews

[alansidman]

Sort your table on Manager and then dates so it looks like this:
Data Range

	A	B	C	D
1	Customer	Submit Date	Manager
2	236166	7/19/2013	Andrews
3	236166	7/19/2013	Andrews	0
4	251285	9/30/2013	Andrews	73
5	251285	9/30/2013	Andrews	0
6	251285	9/30/2013	Andrews	0
7	251285	9/30/2013	Andrews	0
8	251285	9/30/2013	Andrews	0
9	236104	7/2/2013	Jackson
10	248058	9/30/2013	Smith
11	248058	9/30/2013	Smith	0
12	80313	9/30/2013	Thompson
13	80313	9/30/2013	Thompson	0
14	80313	9/30/2013	Thompson	0

Then in cell D3, put this formula and copy it down.

=IF(C2=C3,DATEDIF(B2,B3,"d"),"")