IF Statement Help based on answer in a cell

[rhett7660]

Hello,

Here is what I have:

D13 = Date received
E13 = Due Date =(DATE(YEAR(D13),MONTH(D13),DAY(D13)+10))
F13 = Date Completed
G13 = Extension with drop down of "yes" or "no"
H13 = this is where I need to insert the IF statement, I am looking for IF G13= Yes, then calculate D13 +24 days.

I haven't been able to get the if statement to work.....

[oeldere]

H13 =if(g13="yes",D13+24,"")

D13 needs to be formatted as date.

[rhett7660]

H13 =if(g13="yes",D13+24,"")

D13 needs to be formatted as date.

Good lord, that was way to easy! I had a huge formula I was working with and it was just that!

Thank you very very much!!!