Working with dates

M

matt330

I've spent far too long on a seemingly simple problem, calculating date
windows.

I have a cell that calculates a date based on another date. This is a
template with no data entered yet. So for instance A1 is a column
where a date will be entered, A2 adds 15 to that date and A3 adds 30 to
that date providing a "window." Being that this is a template and no
data has been entered, when the formulas are written in to A2 and A3
the value is 15-Jan-1900 and 30-Jan-1900.

Is there anyway to leave these fields Blank until a value is entered in
A1?
 
J

Jezebel

As an alternative to Anne's solution, you could use conditional formatting
to hide the results until they are valid:

Format the cell font to white (or whatever your background color). Then set
the condition "Formula is" =(A1>0) and the format is black (or whatever your
foreground color).

Keeps your formulas simpler.
 
M

matt330

Thanks for both of your help. I went with the one that left the fiel
blank, but I'm sure I'll be using the conditional formatting in th
near future.

Thanks again!
 
Top