Thread: Weekdays
View Single Post
  #6   Report Post  
David Biddulph
 
Posts: n/a
Default

"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