Cell Formatting

[Sandy]

I have a date in cell M3 02/07/2007 (format dd/mm/yyyy) and a date in cell
P3 07/08/2007 (format dd/mm/yyyy).
In E3 I have the formula
=IF(AND(M3<>"",P3<>""),CONCATENATE(">",M3),M3)
the result is >39265. I would like the result to be >02/07/2007. I need this
format for copying to the criteria field of a filter.
Any ideas?
Thanks in advance
Sandy

 

[Bob Phillips]

=IF(AND(M3<>"",P3<>""),">"&TEXT(M3,"dd/mm/yyyy"),TEXT(M3,"dd/mm/yyyy"))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sandy]

Perfect Bob thank you
Sandy

=IF(AND(M3<>"",P3<>""),">"&TEXT(M3,"dd/mm/yyyy"),TEXT(M3,"dd/mm/yyyy"))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)