Calculate number of days between two dates within a pivot table.

Hi,

Within my job I have been using Excel to display, sort and present data in a professional way. However, I now need to progress to using a bit of programming. Highly exciting, but I am getting a bit lost. Would appreciate some help from you younger, on the ball experts. I have created a pivot table with two columns below. Column C indicates the start date. Column D indicates the completion date. Blank cells show live data. I need to determine the number of days. 1) That have been - completed - a) That were < 2 Days, b) >2 but less than a week, c) > than a week (all). I have used the following formulas. a) countif(D4:D61, "<3"), b) countifs(D4:D61, ">2", D4:D61, "<=8"). Easy for completed data. My problem is, how do I determine the number of days, live data that following the same queries as above. I have figured out I can use countif to count the number of blanks by - countif(D4:D61, "(blank)") but how to put it all together and what formula should I use. I am trying to use countifs or if statements but am totally lost. I am experimenting with Today() etc. Would be happy for any guidance or direction. Not to old to learn. Cheers.

Column C Column D
---------- ----------
06/01/2014 (blank)
25/11/2013 (blank)
13/12/2013 14/01/2014
27/12/2013 17/01/2014
27/12/2013 10/01/2014
31/12/2013 (blank)
04/01/2014 14/01/2014
07/01/2014 15/01/2014
09/01/2014 14/01/2014
09/01/2014 17/01/2014
09/01/2014 (blank)
09/01/2014 10/01/2014
13/01/2014 (blank)
13/01/2014 15/01/2014
13/01/2014 16/01/2014
13/01/2014 15/01/2014
13/01/2014 (blank)
13/01/2014 16/01/2014
13/01/2014 (blank)
13/01/2014 15/01/2014
13/01/2014 13/01/2014
13/01/2014 (blank)
13/01/2014 14/01/2014
14/01/2014 14/01/2014
14/01/2014 16/01/2014
ETC

Hi,

Attached the file as requested. Within the diffirent sheet you can see my attempts to solved this issue. Really appreciate your help.