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
|