Dummy question - how to hide data?

[Squidge90]

Hello all!



Apologies in advance for the dummy question. This is myfirst dip into Excel since school and despite scouring the internet for theformula I need, I can’t make Excel do what I want.


So, I have a table that when I insert a date in column C Iwant it to show the date + either 30 or 60 days in column D. My formula forthis is =SUM(C2+60) which seems to work fine, but despite having nothingentered in column C, it is showing the date as 29/02/1900 in the D column whenI’d really rather it doesn’t show anything until I have entered the date incolumn C.


How would I make it hide the date until I have entered thedate in column C?

I hope that makes some sort of sense to someone.



TIA

 

[nemmi69]

something like =IF(C2<-0,"",C2+60)

 

[Joe4]

Welcome to the Board!

It is treated your blank as 0. Since Excel stores dates as the number of days since 00/01/1900, adding 60 gives you 29/02/1900.

Try this formula instead:

=IF(C2>0,C2+60,"")

 

[Joe4]

something like =IF(C2<-0,"",C2+60)

That won't work.
Did you mean?

[COLOR=#333333]=IF(C2<[/COLOR][COLOR=#ff0000]=[/COLOR][COLOR=#333333]0,"",C2+60)[/COLOR]

 

[nemmi69]

Gaaa, typo