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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need formula for: IF K1 = y then M1= the date in A1 + 15 days (https://www.excelbanter.com/excel-worksheet-functions/60294-need-formula-if-k1-%3D-y-then-m1%3D-date-a1-15-days.html)

LizKiz

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

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

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

Thanks!

RagDyer

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

Try this:

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

--
HTH,

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

"LizKiz" wrote in message
...
Can anyone help me with creating a formula for the following:

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

Thanks!

LizKiz

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

Thank you! Worked like a charm!

"RagDyer" wrote:

Try this:

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

--
HTH,

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

"LizKiz" wrote in message
...
Can anyone help me with creating a formula for the following:

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

Thanks!

All times are GMT +1. The time now is 05:42 PM.