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
|