function to return days

Is there any built-in function to return value i.e Monday, Tuesday

It could be done this way (if the date to check is in A1):
=CHOOSE(WEEKDAY(A1,1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")


"crapit" wrote:

> Is there any built-in function to return value i.e Monday, Tuesday
>
>
>

=TEXT(A1,"dddd")

--
HTH

Bob Phillips

"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:ODgZ3VjfFHA.2156@TK2MSFTNGP14.phx.gbl...
> Is there any built-in function to return value i.e Monday, Tuesday
>
>

=TEXT(A1,"dddd")

Or just format the date as dddd, so that it remains a date

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
"crapit" <littlecramP@yahoo.com.sg> wrote in message
news:ODgZ3VjfFHA.2156@TK2MSFTNGP14.phx.gbl...
> Is there any built-in function to return value i.e Monday, Tuesday
>