Formula In Excel To Prompt User To Input Date

[pclutts]

I have a cell (C16) that has a date format (such as 08/28/2014). I want the value of this cell to be “N/A” when cell C7 is “No”. When C7 is “Yes”, I want Excel to prompt the user to enter a date when they click on cell C16. The formula for cell C7 is =IF(C3="No","No","Yes"). That's where the value of C7="No" comes from. If I didn't need a date for the value of C16, the formula would be something like =IF(C7="No","N/A","______").



My apologies but I need to be led by the hand here. I have never created a macro/module in Excel before. Can anyone out there suggest a solution for me? Thanks in advance for any advice.