count number of dates within given time period

Hi all,

I am completely at a loss for how this can be done or even if it can be done at all....

I have attached a copy of a sheet with dummy data entered. I'm looking for 2 formulas to count the number of people who are seen within 3 weeks of referal and then either discharged within 6 weeks (formula 1) or given a perscription within 6 weeks and then go on to receive 4 or more follow appoinments within 1 year (formula 2).

Ideally formual 1 (Number seen within 3 weeks of referal and discharged within 6 weeks) would return 1 (person 3) and formual 2 (Number seen within 3 weeks, given prescription within 6 weeks and receive => 4 follow up appointments) would return 1 (person 1).

Many thanks in advance for any help,