Day date format

[Anthony]

Using the custom date format I got from these forms, which works great thank
you.
dddd mmmm d, yyyy I of course get the correct results. My question is can I
use a date format that would put the day of the week over the date.

Friday
September 10, 2004

Thanks for any replies in advance.

 

[Anthony]

I may be asking a little too much here, but if I name a sheet using a date.
For instance, 09-10-04 would there be a formula that would take that name and
insert it into a specific cell using the format dddd mmmm d, yyyy

 

[Dave Peterson]

You can use a custom format of:

dddd_mmmm dd, yyyy

But don't type the underscore--instead, hit and hold the alt key and type 0010
from the numeric keypad--not the numbers above the QWERTY keys.

And make sure that the cell is set for wordwrap.

But you'll have to resize the rowheight manually. And if you make the
columnwidth too small, you'll get ####'s. And too small is based on what it
looks like--it's based on that whole string--just like if it were on one line.

It might look better if you used a formula:

=text(a1,"dddd")&char(10)&text(a1,"mmmm dd, yyyy")

 

[Dave Peterson]

I used this formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

From Debra Dalgleish's site:
http://www.contextures.com/xlfaqFun.html#SheetName

Then I modified it to:
=DATEVALUE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255))

And I used the same formatting as in the other post.

 

[RagDyer]

It can be done with a custom format.

FIRST:
<Format> <Cells> <Alignment> tab,
In the "Horizontal" AND "Vertical" box, expand them and choose "Center" for
both,
And then check "WrapText".

Then:
<Number> tab,
Click "Custom" in the left window, and then in the "Type" box,
Enter:
dddd
Then hold down the <Alt> key,
And using the num keypad (*not* the numbers under the function keys), enter
0010
Then enter
mmmm d, yyy
And then <OK>.

This should give you what you're looking for.

If the date is still on one line, and you see a white square in the cell,
between the day and month, you forgot to check "WrapText".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
and


I may be asking a little too much here, but if I name a sheet using a date.
For instance, 09-10-04 would there be a formula that would take that name
and
insert it into a specific cell using the format dddd mmmm d, yyyy

 

[Anthony G of La Quinta]

Thanks to you both, it worked perfectly!

You can use a custom format of:

dddd_mmmm dd, yyyy

But don't type the underscore--instead, hit and hold the alt key and type 0010
from the numeric keypad--not the numbers above the QWERTY keys.

And make sure that the cell is set for wordwrap.

But you'll have to resize the rowheight manually. And if you make the
columnwidth too small, you'll get ####'s. And too small is based on what it
looks like--it's based on that whole string--just like if it were on one line.

It might look better if you used a formula:

=text(a1,"dddd")&char(10)&text(a1,"mmmm dd, yyyy")