Nested IF help

[nikhil0311]

	A	B	C	D	E	F	G
1	Output	Migration Date	Renewal Date	5 month prior date (migration dt column B -(substract) 5 months prior)	Risk	Flag	Final Comment
2	Yes	Sunday, March 1, 2020	Friday, July 5, 2019	Tuesday, October 1, 2019	Low	PEP	Ready to Migrate
3	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
4	No	Monday, June 18, 2018	Sunday, January 1, 2017	Thursday, January 18, 2018	High	No	3 update to UK standard required - remedation
5	No	Thursday, November 14, 2019	Wednesday, June 3, 2020	Friday, June 14, 2019	High	No	4 update to target location scheduled renewal
6	No	Wednesday, June 3, 2020	Monday, June 18, 2018	Friday, June 14, 2019	Low	PEP	5 update to target location - Remediation

<thead>
</thead><tbody>
</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