So I basically no nothing about Excel formulas, but I've caught on doing basic stuff throughout the day, and now I'm at the trick part where I need some help.

First Issue
One of my cells, say A1, reflects a date that I type in. In return I would like cell B1 to auto-populate a date 7 days later than the A1 date.

Second Issue
One of my cells, say A1, contains a drop down list with 2 options, Yes and No. When I select "Yes" in cell A1 I would like cell B2 to basically "gray" out so no one tries to type anything in B2 if they selected "yes" for A1.


These are both way easier than what I'm making it seem, but I've given myself a headache with it so far!

Thanks in advance for any help and I apologize if I've repeated a past thread, I promise I tried searching.