Adding the DAY to a Date field?

[kelemvor]

Is there some way I can have Excel 2k put the DAY that corresponds to
specific date? So if I type in 6/9/04 it would put in Wednesda
6/9/04?

Not sure if that's included anywhere.

Thanks

 

[Earl Kiosterud]

kelemvor,

Use dddd in a custom format (Format - Cells - Number - Custom):
dddd d-mmm
dddd mmm dd, yyyy
dddd mm/dd/yy

 

[Ron Rosenfeld]

Is there some way I can have Excel 2k put the DAY that corresponds to a
specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.

Format/Cells/Date and choose the format that includes the day.

Or

Format/Cells/Custom Type: dddd d/m/y


--ron

 

[kelemvor]

Excel2k doesn't seem to have the built in option that has the Day but
was able to edit it in the custom area and it works fine.

Thanks

 

[Dave Peterson]

One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!

 

[Earl Kiosterud]

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

 

[Dave Peterson]

I really like to use the 4 digit year, too!

and one more:

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010 from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

 

[Earl Kiosterud]

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square in
the cell where the 0010 code was in the format code. XL2002.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I really like to use the 4 digit year, too!

and one more:

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010 from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

 

[Dave Peterson]

I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square in
the cell where the 0010 code was in the format code. XL2002.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I really like to use the 4 digit year, too!

and one more:

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010 from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!



:

Is there some way I can have Excel 2k put the DAY that corresponds to a
specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.

 

[Earl Kiosterud]

Dave,

Thanks. This made me realize that even when you put a LF (Alt-Enter or
CHAR(10)) in text in a cell, wrap text must be on (it gets turned on
automatically). I dinna know that. Sounds as if they should have named it
"multiline," not "wrap text."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square in
the cell where the 0010 code was in the format code. XL2002.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I really like to use the 4 digit year, too!

and one more:

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010 from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004




Earl Kiosterud wrote:

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!



:

Is there some way I can have Excel 2k put the DAY that

corresponds
to a

specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.

 

[Dave Peterson]

Excel seems smart enough to notice when you do the alt-enter manually--but I've
never seen it do it if it's part of a formula.

Dave,

Thanks. This made me realize that even when you put a LF (Alt-Enter or
CHAR(10)) in text in a cell, wrap text must be on (it gets turned on
automatically). I dinna know that. Sounds as if they should have named it
"multiline," not "wrap text."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Dave,

I couldn't get the Alt-0010 to work. It drops to a second line in the
custom format box as you would expect (I have to arrow up and down -- it
only shows one line at a time in that box). But it just puts a square in
the cell where the 0010 code was in the format code. XL2002.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I really like to use the 4 digit year, too!

and one more:

dddd[alt-0010]mm/dd/yyyy

where [alt-0010] is not typed. Hit and hold the alt-key and type 0010
from the
numeric keypad.

It looks nice centered in the cell--but it doesn't behave very nicely with
autofitting rows or columns.

Looks kind of like this:

Sunday
06/13/2004




Earl Kiosterud wrote:

And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!



:

Is there some way I can have Excel 2k put the DAY that corresponds
to a
specific date? So if I type in 6/9/04 it would put in Wednesday
6/9/04?

Not sure if that's included anywhere.

Thanks.