Measure for Counting active days from 3 different Tables

[Mavericks334]

Hi,
I have 3 tables, which has a column name completed date. From these 3 tables i need to get the no of active days or no of working days of each person. The dates could be repeated in mutliple times in each table based on the tasks the person is performing. Below are the column heading of each of these tables.

SharePoint Data:
[TABLE="width: 532"]
<COLGROUP><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4132" span=2 width=113><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><TBODY>[TR]
[TD="class: xl116, width: 122, bgcolor: #8db4e2"]Completed Date[/TD]
[TD="class: xl115, width: 128, bgcolor: #8db4e2"]Recon Category[/TD]
[TD="class: xl115, width: 72, bgcolor: #8db4e2"]Frequency[/TD]
[TD="class: xl115, width: 113, bgcolor: #8db4e2"]Fund Complexity[/TD]
[TD="class: xl115, width: 113, bgcolor: #8db4e2"]Centralized Complexity[/TD]
[TD="class: xl115, width: 77, bgcolor: #8db4e2"]Preparer ID[/TD]
[TD="class: xl115, width: 82, bgcolor: #8db4e2"]Reviewer ID[/TD]
[/TR]
</TBODY>[/TABLE]

Manually Tracked Data:
[TABLE="width: 532"]
<COLGROUP><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4132" span=2 width=113><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><TBODY>[TR]
[TD="class: xl116, width: 122, bgcolor: #8db4e2"]Completed Date[/TD]
[TD="class: xl115, width: 128, bgcolor: #8db4e2"]Recon Category[/TD]
[TD="class: xl115, width: 72, bgcolor: #8db4e2"]Frequency[/TD]
[TD="class: xl115, width: 113, bgcolor: #8db4e2"]Fund Complexity[/TD]
[TD="class: xl115, width: 113, bgcolor: #8db4e2"]Centralized Complexity[/TD]
[TD="class: xl115, width: 77, bgcolor: #8db4e2"]Preparer ID[/TD]
[TD="class: xl115, width: 82, bgcolor: #8db4e2"]Reviewer ID[/TD]
[/TR]
</TBODY>[/TABLE]


In these two table the persons id could be either in the preparer id field or reviewer id field, it has to check to both these columns.

Project Data.
[TABLE="width: 387"]
<COLGROUP><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 144pt; mso-width-source: userset; mso-width-alt: 7021" width=192><COL style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 5010" width=137><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><TBODY>[TR]
[TD="class: xl117, width: 109, bgcolor: #8db4e2"]Completed Date[/TD]
[TD="class: xl118, width: 192, bgcolor: #8db4e2"]Type[/TD]
[TD="class: xl117, width: 137, bgcolor: #8db4e2"]Time Spent (in mins)[/TD]
[TD="class: xl118, width: 77, bgcolor: #8db4e2"]Preparer ID[/TD]
[/TR]
</TBODY>[/TABLE]

The measure should be able to check each of these columns and give the no of working days.

Regards,
Ren.