Working with dates

[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?

 

[Anne Troy]

Sure, Matt. Suppose you have this in A2:
=A1+15
Change it to:
=IF(ISBLANK(A1),"",A1+15)
************
Anne Troy
www.OfficeArticles.com

 

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

 

[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!