Need Help In learning how to hide a date on a worksheet

[Stan Gilbert]

In my office we review County Disaster Plans and we are
setting up a worksheet to show us when the next plan is
due for review, which normally is one year from the
previous review date. When I enter the formula =B2+365 it
gives us the data we need but until the current
information (date) is inserted into the cell B2 the cell
which contains the formula displays 12/30/1900. Is there a
way to hide this date or is there another formula we can
use that would allow us to input the current date in one
cell (B2) and the new date appears in the cell with the
formula (H2). I hope this makes sense to some of you and
someone will be able to lean a hand in figuring this out.
you can email me if you need further information on what
we are attempting to do.
..

 

[Vasant Nanavati]

=IF(B2="","",B2+365)

 

[Bob Phillips]

Have you not seen the responses to this question on Friday last?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Vasant

Thanks so much, it worked perfectly

Sta

----- Vasant Nanavati wrote: ----

=IF(B2="","",B2+365

 

[Kent]

Your formula is returning 365 in a date format which
suggests B2 is zero or blank. Try this:

=IF(B2="","",B2+365)

Excel Support Technician
www.canhelpyou.com