Hospital patients - If readmission determine whether within 30 days of most recent discharge.

[Glen_Yorkshire]

Hi

I have a list of hospital patients each with a unique Patient ID, a date of Admission and a date of Discharge.
For each readmission I need to indicate if it happened within 30 days their most recent discharge.

This is an example of what I am aiming for....

I have managed (in column D) to add 30 days to the Discharge date but this is as far as my Excel skills reach. Column F is what I need to calculate. In the above screenshot I have manually entered 'Yes' and 'No' to show my intention.

Thanks
Glen

 

[Glen_Yorkshire]

 

[Glen_Yorkshire]

battling to save my screenshot....

Patient ID	Admission Date	Discharge Date		30 Day Readmission?
1	01/01/2015	03/01/2015	02/02/2015		No
2	20/06/2015	07/07/2015	06/08/2015		No
2	10/07/2015	14/07/2015	13/08/2015		Yes
2	15/08/2015	15/08/2015	14/09/2015		No
2	13/09/2015	20/09/2015	20/10/2015		Yes
3	25/04/2015	29/04/2015	29/05/2015		No
3	01/06/2015	06/06/2015	06/07/2015		No
3	01/07/2015	05/07/2015	04/08/2015		Yes

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>