Hi I work for the NHS and I need to count some values between a date range by a patient number. These are on 2 seperate sheets.

For example

Sheet1

A B C D
Pat1 11/09 14/09 Formual in here
Pat2 14/09 18/09 Formual in here
Pat3 20/09 25/09 Formual in here
Pat4 29/03 29/04 Formual in here
Pat5 30/04 05/05 Formual in here


Raw data sheet
A B C D
Pat1 * 14/09 *
Pat1 * 14/09 *
Pat1 * 15/09 *
Pat2 * 13/09 *
Pat2 * 14/09 *
Pat2 * 15/09 *
Pat2 * 16/09 *
Pat2 * 17/09 *
Pat2 * 19/09 *


The formual in collum D1 should retun back 2 and D2 should return back 4.