One way - date in A1:

=TEXT(A1,"DDD") & " " & TEXT(A1,"dd/mm/YYYY")

"sharkey" wrote:

> I need to show the day and the date in the same cell
>
> tue 27/02/06
> wed 28/02/06
>
> can anyone help please
>