03856me
Active Member
- Joined
- Apr 4, 2008
- Messages
- 297
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!
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!
