How do I write a special date formula in Excel?

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.  

Thank you.
sherman6789Asked:
Who is Participating?
 
Jerry MillerConnect With a Mentor Commented:
You don't want to do the TODAY or NOW function here because it will always be updating to the current date + 15 days. You want to use the original cell value + 15.

Put this formula in C10.

=If (C2 = 'Y', C10=C1+15)

Here is a reference:
http://www.techonthenet.com/excel/formulas/if.php
0
 
Jerry MillerConnect With a Mentor Commented:
0
 
Kyle AbrahamsConnect With a Mentor Senior .Net DeveloperCommented:
This would go in C10
=IF(C2="Y", Today()+15, Today())

Be sure to format the cell (c10) as a date.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Joe MikaConnect With a Mentor Commented:
Jerry is right, if you use today each time the spreadsheet is opened it will update.

You may want to put completion date in C3 or somewhere, and mark that and C10 as date cells, then you could do
=IF(C2="y",C3+15,"N/A")
0
 
sherman6789Author Commented:
Thanks everyone for your suggestions and comments.  I had to go out of town for the job.  Since I am back I will work on updating and testing the project.  I will end the thread soon.

This is great.

Thanks again.

-sherman6789
0
 
sherman6789Author Commented:
Thanks for your answers.  They are all helping us on our projects.

-sherman6789
0
All Courses

From novice to tech pro — start learning today.