How do I write a special date formula in Excel?
If cell C2 = "Y" I would like today's date plus 15 days to be automatically entered into cell C10.
I am guessing that it would be something like: =If (C2 = 'Y') then C10=TODAY()+15
Also, where do I put the formula? I looked at the Conditional Formatting area but it seems to be available for changing the color of the cell.
Let's say that today is: March 5, 2014. A project listed on C1 was completed today and a completion notice has been placed into cell C2: "Yes". The user should send an email notice to John immediately letting him know that step 2 should be sent out 15 days after the project is finished. Therefore, I want the system to automatically enter "3/20/2014" into cell C10.
Any assistance that you can give will be appreciated.