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
>
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks