Adding the DAY to a Date field?

K

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
 
E

Earl Kiosterud

kelemvor,

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

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

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

Or

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


--ron
 
K

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
 
D

Dave Peterson

One more format that I find pretty neat:

dddd* mm/dd/yyyy

Watch what happens when you widen the column!
 
E

Earl Kiosterud

And try these.

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

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




Earl said:
And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy
Click to expand...
 
E

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
-------------------------------------------

Dave Peterson said:
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 said:
And try these.

dddd *- dd/mm/yy
dddd ** dd/mm/yy
dddd *. dd/mm/yy
dddd*.dd/mm/yy
Click to expand...
Click to expand...
 
D

Dave Peterson

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

(also xl2002)

Earl said:
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
-------------------------------------------

Dave Peterson said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
E

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
-------------------------------------------

Dave Peterson said:
I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Earl said:
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
-------------------------------------------

Dave Peterson said:
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
Click to expand...
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.
Click to expand...
Click to expand...
Click to expand...
 
D

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.



Earl said:
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
-------------------------------------------

Dave Peterson said:
I should have mentioned that Wraptext has to be enabled, too.

(also xl2002)

Earl said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Top