Date Formula and leaving cell blank when no date is entered

I am needing to create a formula to add 7 days to a certain date entered, but if no date is entered I need the cell to remain blank

EX.
A1 blank C1 blank
A1- 2/1/2015 need C1 2/8/2015
and so on for the remaining cells that will follow down the sheet

Any help would be appricated as I am not an excel guru

Thanks

Hello
try this
=IF(A1="","",A1+7)

Tell me if it works right….

Hope it helps
Do ask for any other query you may have…

If you are satisfied then mark then PLEASE mark this thread as “SOLVED” (by going to thread tools at the top and clicking on “mark this thread as solved”) and you can just click on ADD REPUTATION below my post to say thanks...

Regards
Sourabh Gupta

Tried that is it didnt work

I think then you have an issue with the format ...maybe your date is formatted as text or something
So if you could just upload a sample workbook..

Click on GO ADVANCED and use the paperclip icon to open the upload window.

http://www.excelforum.com/members/da...ch-a-file.html

Alkey it worked.

Thanks a bunch.

Now if I can just figure out how to condition the cell to turn red when the date equals the current date I will be good to go