Day of week in date

[Alex]

Hi, is it possible to format a cell to show the day of week as well as
date - eg Saturday 7th February 2004?

Thanks

 

[JE McGimpsey]

Try:

Format/Cells/Numbers/Custom dddd d mmmm yyyy

Note: to get the ordinal you'd need to use a worksheet function or VBA.

 

[Alex]

Thanks

Try:

Format/Cells/Numbers/Custom dddd d mmmm yyyy

Note: to get the ordinal you'd need to use a worksheet function or VBA.

 

[James Silverton]

Hi, is it possible to format a cell to show the day of week as well as
date - eg Saturday 7th February 2004?

Thanks

In Word XP, it is one of the choices for Date in Format Cell. There
are a couple of commas so you might need to do a custom format if you
don't like them.

 

[Norman Harker]

Hi Alex!

Based on some ordinal code from Chip Pearson

For today:
=TEXT(TODAY(),"dddd
")&DAY(TODAY())&IF(AND(DAY(TODAY())>=10,DAY(TODAY())<=14),"th",CHOOSE(
MOD(A1,10)+1,"th","st","nd","rd","th","th","th","th","th","th"))& " "
&TEXT(TODAY(),"mmmm yyyy")

For a date in A1:
=TEXT(A1,"dddd
")&DAY(A1)&IF(AND(DAY(A1)>=10,DAY(A1)<=14),"th",CHOOSE(MOD(A1,10)+1,"t
h","st","nd","rd","th","th","th","th","th","th"))& " " &TEXT(A1,"mmmm
yyyy")

But note that this is text and will be difficult to use in a
calculation.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[pylie]

Thank you so much. I have been trying to work this one out for the past year (off and on, of course). This is a great help. Thx!