Weekdays

J

Jeff

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,
 
R

Roger Govier

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!!!
 
C

CyberTaz

Jeff-

One way is to use the WEEKDAY() function and apply a custom format to the
cells using dddd for full spelling, ddd for 3-char. abbreviations.

Hope this is helpful |:>)
 
P

Peo Sjoblom

It's not possible since the 15th is a Tuesday <g> You can either directly
link to the cell

=A10

and use a custom format like dddd

or use the text function

=TEXT(A10,"dddd")
 
J

JE McGimpsey

No need for a worksheet function, just use

B10: =A10

and format it with Format/Cells/Number/Custom dddd
 
D

David Biddulph

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 ?
Click to expand...

=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")
 
D

Dave Peterson

Maybe you could just include the date and day in A10:

Format|cells|number tab|custom
type:
dd-mmm-yy* dddd

If you expand the column width, you'll see how that "* " works.
 
Top