First, thank you for helping. I hope this makes sense.

I'm trying to come up with a formula that will display the AVERAGE amount of
days a PO is open. The data that I have is:
PO Item Date Open Date Closed
1 1 01-25-09 02-15-09
1 2 01-30-09
1 3 02-05-09
2 1 02-14-09 02-25-09
3 1 02-25-09
4 1 03-02-09
4 2 03-02-09
For the items still open (date closed is blank) I want to average those only
by using the TODAY() function in the formula where the item is open, can this
be done?
The result I'm trying to find is:
PO Avg Days Open
1 168
2 0
3 152
4 149

Thank you in advance
Joe