function to return days
 

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

function to return days
 

=TEXT(A1,"dddd")

--
HTH

Bob Phillips

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

function to return days
 

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

function to return days
 

=TEXT(A1,"dddd")

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
"crapit" wrote in message
...
Is there any built-in function to return value i.e Monday, Tuesday