I have column B with a date, I have column C with a formula (I have =(B1+180) in column C) I need the text in cell c1 to be visible. How do I do this?

Cheryl

I am using excel 2010. I am an excel beginner. I have column b formated as a date. I have column C formated with the date from column B and adding 180. The formula in column C is: =(B2+180). This works fine. However, now I need to figure out how to only disply the information in column C if column B is filled in.
EX:
column A Column B Column C
(info should not be visible in Column "C" if no
info is in "B")


Equipment #

PM Complete date

PM Due Date




010-008-003

16-Apr

10/13/2014




010-129

16-Apr

10/13/2014




010-159


6/28/1900




036-136


6/28/1900




036-137


6/28/1900

Try:

=IfBlank(B2),"",(B2+180))

Thank you for your quick reply, unfortunately I got an error message:
"The formula you typed contains an error"
I wish I could share the file or a screenshot with you.

45938

Sorry, my memory is failing. Try:

=IF(ISBLANK(B2),"",B2+180)

That works, thank you very much!
:)

Glad to assist. Sorry for the brain fart.