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

G

Guest

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

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

Thanks!
 
R

RagDyer

Try this:

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

--
HTH,

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

Guest

Thank you! Worked like a charm!

RagDyer said:
Try this:

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

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nesting more than 7 functions? 11
How to set cell value to emptry if three other columns are empty too 1
How do I combine the 4 IF formulas into 1 formula 5
Does date in Cell A1 occur between the date in M1 and Date in X1 1
help with 12 week rolling average 3
Count repeats 7
Returning a YES or NO if there is a value on a range of cells 0
formula to track timeframe by automatically highlighting cells 6

Top