Excel nested if too many arguments fix without lookup -

I know that this question has been asked before. I want to know that it is possible to fix it without using a lookup with the index function. I looked at the question and tried to add to me and there was no success.

This is my formula:

= IF (C49 = "", "", IF (R49 = "2 months / month", DATE (YEAR (C49) (C49) + 2, Day (C49), if (R49 = "3 Month / Month", Date (Year (C49), Month (C49) + 3, Day (C49) ), If (R 49 = 4 months / month ", DATE (YEAR (C49), MONTH (C49) + 4, day (C49)) if (R49 =" 5 months / month ", DATE ( YEAR (C49), MONTH (C49) +5, day (C49), if (R49 = "6 months / month", date (year (c49), month (c49) + 6, Day (C49), if (R49 = "7 months / month", DATE (C49), MNST (C49), MONTH (C49) +7, Day (C49)) , If (R = 49 = "8 months / Hena ", DATE (year (C49), MONHT (C49) +8, Day (C49) IF (R49 =" 9 months / month ", DATE (year (c49), month (c) 49) + 9, Day (C49), if (R49 = "10 month / month", date (year (c49), month (c49) + 10, day (c49)) , If (R49 = "11 months / month", date (year (C49), month (C49) + 11, day (C49)), if (R49 = "12 months / mois" DATE (YEAR (C49), MONTH (C49) +12, DAY (C49)), "0")))))))))))))))))

I How can I modify this formula that does not get too much logic error?

You can avoid many IF statements using:

  = DATE (YEAR (C49), MONTH (C49) + LEFT (R49,2), DAY (C49))  

This will automatically connect months with two first characters Edit:

Edit:

If you want to check that C49 and R49 are empty, you can use it:

< Previous> = IF (C49 = "", IFERROR (DATE (YEAR (C49), MONTH (C49) + LEFT (R49,2), DAY (C49), "0")

If C49 is December 31 and you add 2 months So what do you expect?

If you want it to be February 28th, then you should use the approach of @ Bardi Houdini to my formula (based on your Nested) on March 3 I will return