Need formula for: IF K1 = y then M1= the date in A1 + 15 days

[LizKiz]

Can anyone help me with creating a formula for the following:

If K1=y, then M1=date in A1+15 days

Thanks!

 

[RagDyer]

Try this:

=IF(AND(K1="y",A1>0),A1+15,"")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[LizKiz]

Thank you! Worked like a charm!

Try this:

=IF(AND(K1="y",A1>0),A1+15,"")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================