If... then?

[CarpeDM]

I have to calculate the days after we receive a notice to when we have to reply. I have two columns column A contains a date when the form was sent out but sometimes I don't have the date the form was sent and I have to go by when the form was filled out (column B). my formula in column C is "=date(year(a1),month(a1),day(a1)+15)" But when I only have the date the form was filled out then my formula in column C is "=date(year(b1),month(b2),day(b2)+15)".

My question is:

Is there a formula I could enter into column C that would select which column to use? And say if I have both dates and I want to use the later one, is that possible?

Any help would be greatly appreciated.

 

[DutchDiggy]

Maybe too easy.. Don't know. I might miss something:

 =if(b1>a1,date(year(b1),month(b1),day(b1)+15),date(year(a1),month(a2),day(a2)+15))

 

[Teeroy]

If B1 and B2 are both formatted as dates (not text) then you only need:

C1: =MAX(A1+15,B1+15)

Make sure C1 is also formatted as a date.

 

[CarpeDM]

Thank you both! They both worked out, and just for simplicity i'm going to use the shorter one. Thank you agian.