Hide Formula value while copying to other cells

[puravsays]

Hi,
I am working with Excel-2003.
While dragging the formula of a row to below, the rows will show a default vaule of the formula, especially in case of dates.
e.g A1=1-feb-11 and B1=A1+15 i.e 16-feb-11. Now, when dragged to B2, it will show 15-Jan-00; and when u delete it, the formula also got deleted.

How can I hide 15-Jan-00, and make cell blank, while formula A2+15 is still active?

..i've searched many related threads, but it did'nt helped!

 

[Dryver14]

Try this

Excel Workbook
	A	B
1	01/02/2011	16/02/2011
2
Sheet1

 

[puravsays]

hey, thanx a lot..
its working.. i've never explored logic func!!