Hi All,

I would be really grateful for some assistance please.

I have 2 seperate spreadsheets of data (I have pasted them into 2 worksheets in the attached zip file)

I need to do the following;

For all User ID's (column D in Contingent Staff) I need to calculate how many timesheets I should have received to date (date being date when report is run) based on how many weeks between start date (column F Contingent Staff) and end date (column G Contingent Staff) this will be based on week ending dates (Sunday being the week end date) (example, timesheets for period 18 February to 2 March 2008 = 1 week (week ending 24 Feb) and 1 week (week ending 2 March)

Once I have this information I need to look up the User ID (column D Contingent Staff) in User ID (column H Timesheet Detail) If I do not find a timesheet for the week ending period then create a table of all missing timesheets showing User ID, ID (column B Timesheet Detail), X-Ref PO ID (column D Timesheet Detail), Contingent Staff First Name (column I Timesheet Detail), Contingent Staff Last Name (column K Timesheet Detail), Timesheet missing for Week Ending Date.

I have attached an example of the data, I really hope the above makes sense.

Thanks in advance,

Marshybid