Nested IF help

[nikhil0311]

	A	B	C	D	E	F	G
Yes	Sunday, March 1, 2020	Friday, July 5, 2019	Tuesday, October 1, 2019	Low	PEP	Ready to Migrate
No	Tuesday, February 12, 2019	Tuesday, January 1, 2019	Wednesday, September 12, 2018	High	No	2 update to UK standard required at next schedule renewal
No	Monday, June 18, 2018	Sunday, January 1, 2017	Thursday, January 18, 2018	High	No	3 update to UK standard required - remedation
No	Thursday, November 14, 2019	Wednesday, June 3, 2020	Friday, June 14, 2019	High	No	4 update to target location scheduled renewal
No	Wednesday, June 3, 2020	Monday, June 18, 2018	Friday, June 14, 2019	Low	PEP	5 update to target location - Remediation

<thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #BDD7EE"]Output[/TD]
[TD="bgcolor: #BDD7EE"]Migration Date[/TD]
[TD="bgcolor: #BDD7EE"]Renewal Date[/TD]
[TD="bgcolor: #FFD966"]5 month prior date (migration dt column B -(substract) 5 months prior)[/TD]
[TD="bgcolor: #BDD7EE"]Risk[/TD]
[TD="bgcolor: #BDD7EE"]Flag[/TD]
[TD="bgcolor: #FFD966"]Final Comment[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

</tbody>

Sheet2​

Raw data is available from Column A to C & E to F
I need to calculate column D i.e. (column B Migration date -(substract) 5 months prior) and then based on below conditions final comments in Column G


If Output i.e. column A is Yes then Final comment i.e. Column G should be "Ready to Migrate"
If Output i.e. column A is No AND Column D date is less than Renewal date i.e. column C then Final comment i.e. Column G should be "2 update to UK standard required at next schedule renewal"
If Output i.e. column A is No AND Column D date is Greater than Renewal date i.e. column C then Final comment i.e. Column G should be "3 update to UK standard required - remedation"
IF column E i.e. Risk is High OR Column F i.e. Flag = PEP AND Column D date is less than Renewal date i.e. column C then final comment i.e. column G should be "4 update to target location scheduled renewal"
IF column E i.e. Risk is High OR Column F i.e. Flag = PEP AND Column D date is Greater than Renewal date i.e. column C then final comment i.e. column G should be "5 update to target location - Remediation"

let me know if you have any questions