How do I code the spreadsheet for a follow-up chart? (See example)

Hi all, I am trying to make a spreadsheet that has the following:

| Col A | Col B | Column C | Column D | Column E | Column F |
| Name | Identifier | Size of lesion (a,b,c) | Risk (high/low) | Date of service | Date of Follow-up |

What I am looking for is if I put in:

size a and low risk, date of f/u = None needed
size a and high risk, date of f/u = <date of service + 365> (one year)
size b and low risk, date of f/u = <DOS + 365>
size b and high risk, date of f/u = <DOS + 180> to <DOS + 365>
size c and low risk, date of f/u = <DOS + 180> to <DOS +365> AND <DOS + 545> to <DOS + 730>
size c and high risk, date of f/u = <DOS + 90> to <DOS + 180> AND <DOS + 270> to <DOS + 365>

I hope that makes sense and someone can help me out on this.
Thanks,
Criss (Sifubear)

I got the answer I needed on the Microsoft Forums. Thank you anyway!

FYI:

=IF(AND(C2="A",D2="Low"),"None needed",IF(OR(AND(C2="A",D2="High"),AND(C2="B",D2="Low")),TEXT(EDATE(E2,12),"dd-mmm-yy"),IF(OR(AND(C2="B",D2="High"),AND(C2="C",D2="Low")),TEXT(EDATE(E2,6),"dd-mmm-yy")&" to "&TEXT(EDATE(E2,12),"dd-mmm-yy")&IF(C2="C"," AND "&TEXT(EDATE(E2,18),"dd-mmm-yy")&" to "&TEXT(EDATE(E2,24),"dd-mmm-yy"),""),IF(AND(C2="C",D2="High"),TEXT(EDATE(E2,3),"dd-mmm-yy")&" to "&TEXT(EDATE(E2,6),"dd-mmm-yy")&" AND "&TEXT(EDATE(E2,9),"dd-mmm-yy")&" to "&TEXT(EDATE(E2,12),"dd-mmm-yy"),""))))