Trying to convert date to day
 

I am trying to convert a date, column A(ie 01/16/2006), to the day of the
month, column B, that this date format represents.
column column
A B
01/16/2006 Thursday

Is this possible or am I in another demention.
--
icky

Trying to convert date to day
 

Nope, you aren't in another dimension. If you just want the day displayed,
you can use this formula:

=LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{"Sunday","Mon day","Tuesday","Wednesday","Thursday","Friday","Sa turday"})

There may be an easier way, but this works.

"icky" wrote:

I am trying to convert a date, column A(ie 01/16/2006), to the day of the
month, column B, that this date format represents.
column column
A B
01/16/2006 Thursday

Is this possible or am I in another demention.
--
icky

Trying to convert date to day
 

=text(a1,"dddd")

But I think I'd use a custom format in column A:

mm/dd/yyyy* dddd

And widen the column.


icky wrote:

I am trying to convert a date, column A(ie 01/16/2006), to the day of the
month, column B, that this date format represents.
column column
A B
01/16/2006 Thursday

Is this possible or am I in another demention.
--
icky

--

Dave Peterson

Trying to convert date to day
 

Barb,

It worked great. Thank you very much.
--
icky


"Barb Reinhardt" wrote:

Nope, you aren't in another dimension. If you just want the day displayed,
you can use this formula:

=LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{"Sunday","Mon day","Tuesday","Wednesday","Thursday","Friday","Sa turday"})

There may be an easier way, but this works.

"icky" wrote:

I am trying to convert a date, column A(ie 01/16/2006), to the day of the
month, column B, that this date format represents.
column column
A B
01/16/2006 Thursday

Is this possible or am I in another demention.
--
icky

Trying to convert date to day
 

Dave,

Your function formula also worked. Thanks for the help.
--
icky


"Dave Peterson" wrote:

=text(a1,"dddd")

But I think I'd use a custom format in column A:

mm/dd/yyyy* dddd

And widen the column.


icky wrote:

I am trying to convert a date, column A(ie 01/16/2006), to the day of the
month, column B, that this date format represents.
column column
A B
01/16/2006 Thursday

Is this possible or am I in another demention.
--
icky

--

Dave Peterson

Trying to convert date to day
 

Dave,

If someone were to use a Pivot Table to evaluate this data, would it work or
not? I'm thinking NOT.

Thanks,
Barb

"Dave Peterson" wrote:

=text(a1,"dddd")

But I think I'd use a custom format in column A:

mm/dd/yyyy* dddd

And widen the column.


icky wrote:

I am trying to convert a date, column A(ie 01/16/2006), to the day of the
month, column B, that this date format represents.
column column
A B
01/16/2006 Thursday

Is this possible or am I in another demention.
--
icky

--

Dave Peterson