AVERAGEIF with String Parsing

First time poster to Excel Forum, so I greatly appreciate your help.

I've been tasked with calculating the average duration of a task across multiple markets. The hard part is the data needed to complete the calculation is included in a cell with two other pieces of information. Trust me, I'd rather break the data into separate columns, but my manager won't let me.

So the task columns can be formatted in one of two ways:

• Complete task = "c" {Date task was completed} (Duration)
• Activate task = {Expected completion date}

Here's an example of the data (attachment might be easier to read):

Market Task_1 Task_2
A c 06/01/11 (42) c 6/1/11 (42)
B 07/25/11 c 06/21/11 (4)
C c 06/01/11 (42) c 06/01/11 (5)
D c 06/05/11 (4) 08/24/11


I thought I was close to completing the calculation using AVERAGEIF and MID, but I can't seem to get a working function. Any ideas?


Thanks,

James