Hi Jeff
Try putting in B10
=CHOOSE(WEEKDAY(A10),"Sunday","Monday","Tuesday"," Wednesday","Thursday","Friday","Saturday")
However, you may find that it is a Tuesday, rather than a Monday - at least
in the UK!!!
--
Regards
Roger Govier
"Jeff" wrote in message
...
Hello,
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 ?
Regards,
|