cell shows unwanted default date

  • Thread starter Thread starter dhager
  • Start date Start date
D

dhager

I used tips on this site to format a cell in column B with the dat
formula: =date(year(A1),month(A1)+6,day(A1)) to get a date 6 month
after date in A.

I copied the formula down the column so the user just needs to fill i
the cell in column A. Cells in Column B fills in with 06/30/00 if ther
is no date filled in column A. Is there a way to keep column B blan
until column A is filled in? Both columns are formatted as Date, so I'
assuming Excel still sees the value in A as some default date.

Thanks

Do
 
DDM,

Thank you much...

I also checked out your web site and appreciate the tips and info.

Do
 
Back
Top