Showing Day and Date in the same Cell

[Colin Hayes]

Hi

I'm trying to show day and date in the same cell like this ;

Wednesday 27/10/2010

I've come up with this formula , but it's not quite working :

=TEXT(TODAY(),"DDDD")&" "&(TODAY())

It's nearly there , but I can't quite get it right.


Can someone help with formula , please?

Grateful for any advice.



Best Wishes

 

[Don Guillett Excel MVP]

Hi

I'm trying to show day and date in the same cell like this ;

Wednesday 27/10/2010

I've come up with this formula , but it's not quite working :

=TEXT(TODAY(),"DDDD")&" "&(TODAY())

It's nearly there , but I can't quite get it right.

Can someone help with formula , please?

Grateful for any advice.

Best Wishes

=TEXT(TODAY(),"DDDD DD/MM/YYYY")
or just put in =today() and custom format the cell(s)

 

[Jim Cone]

=TEXT(TODAY(), "dddd dd/mm/yyyy")

You can eliminate the formula by applying a custom number format to the cell.
That assumes the cell contains a valid date (number).
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(30+ ways to sort)

..
..
..

"Colin Hayes" <[email protected]>
wrote in message
Hi
I'm trying to show day and date in the same cell like this ;

Wednesday 27/10/2010

I've come up with this formula , but it's not quite working :

=TEXT(TODAY(),"DDDD")&" "&(TODAY())

It's nearly there , but I can't quite get it right.
Can someone help with formula , please?
Grateful for any advice.
Best Wishes

 

[Colin Hayes]

=TEXT(TODAY(), "dddd dd/mm/yyyy")

You can eliminate the formula by applying a custom number format to the cell.
That assumes the cell contains a valid date (number).

Excellent - thanks guys for helping out. Both methods work fine.

 

[James Ravenswood]

Hi

I'm trying to show day and date in the same cell like this ;

Wednesday 27/10/2010

I've come up with this formula , but it's not quite working :

=TEXT(TODAY(),"DDDD")&" "&(TODAY())

It's nearly there , but I can't quite get it right.

Can someone help with formula , please?

Grateful for any advice.

Best Wishes

Format the cell as:
dddd dd/mm/yyyy