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

  • Thread starter Thread starter Stan Gilbert
  • Start date Start date
S

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.
..
 
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)
 
Vasant

Thanks so much, it worked perfectly

Sta

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

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