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.

Attachment 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.