=if(a1="something",today(),"")

The "" returns an empty string.

Your formula is returning a 0 and when you format 0 as a date, you'll see
01/00/00.


joe@malvern wrote:

I have formatted a data entry column for dates as follows:
Category=date
type=03/14/01

how can I format the cell to remain blank after using an IF function?
currently it returns 01/00/00

thanks

--

Dave Peterson