Mean Time Between Dates in A Table

[03856me]

I have Table1 setup like:

Column A Date
Column B Type
Column C Amount

I enter a date on a report and based on that date I would like to know how long it has been since that type of order has been placed.

Example: on report I enter 12/31/2010(cell A1)

My report should look like this:
# of Days Last Day of Order
Type 1 - 23 - 12/08/2010
Type 2 - 50 - 11/11/2010
Type 3 - 25 - 12/06/2010

Any help on how to write the formula to calculate the "mean time" days between the 12/31/2010 in cell A1 and then look at the table and find the type with the last instance?

I really appreciate your help.

Stumped on this One!