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....


[TABLE="width: 537"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Patient ID[/TD]
[TD]Admission Date[/TD]
[TD="colspan: 2"]Discharge Date[/TD]
[TD][/TD]
[TD]30 Day Readmission?[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]01/01/2015[/TD]
[TD]03/01/2015[/TD]
[TD]02/02/2015[/TD]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]20/06/2015[/TD]
[TD]07/07/2015[/TD]
[TD]06/08/2015[/TD]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]10/07/2015[/TD]
[TD]14/07/2015[/TD]
[TD]13/08/2015[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]15/08/2015[/TD]
[TD]15/08/2015[/TD]
[TD]14/09/2015[/TD]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]13/09/2015[/TD]
[TD]20/09/2015[/TD]
[TD]20/10/2015[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]25/04/2015[/TD]
[TD]29/04/2015[/TD]
[TD]29/05/2015[/TD]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01/06/2015[/TD]
[TD]06/06/2015[/TD]
[TD]06/07/2015[/TD]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01/07/2015[/TD]
[TD]05/07/2015[/TD]
[TD]04/08/2015[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]