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!
|