Showing Day and Date in the same Cell

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

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
 
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
Click to expand...

=TEXT(TODAY(),"DDDD DD/MM/YYYY")
or just put in =today() and custom format the cell(s)
 
=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
 
Jim Cone said:
=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).
Click to expand...

Excellent - thanks guys for helping out. Both methods work fine.
 
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
Click to expand...

Format the cell as:
dddd dd/mm/yyyy
 
Back
Top