Thanks all
but why using the & as in ="<="&B3

Daniel

"Peo Sjoblom" wrote:

You can use a workaround

="<="&TEXT(B3,"mm/dd/yy")


change the "mm/dd/yy" to whatever date format you are using, I used US date
format in my example

I guess it is because these D and advanced filter functions don't pick up
that B3 is a date so they display the true value of the cell


--


Regards,


Peo Sjoblom




"Daniel" wrote in message
...
hi

when my B3 cell with date 4/05/2007, I don't know why the A3 cell display
serial number

My A3 cell with formula ="<="&B3

Can you explain this?

Thanks
Daniel