"Jeff" wrote in message
...
I have in column "A" row "10" the date as follow: 15-Feb-05.
It is possible to get in column "B" row "10" the day of the week as
follow:
Monday ?
=TEXT(A10,"ddddd") will give you Tuesday
If you really want Monday (i.e. the day before the date you supplied) you
may need to do something like:
=TEXT(A10-1,"ddddd")
--
David Biddulph
|