Just use

=TEXT(C8,"dddd")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"nicojr" wrote in message
...
Hi everyone,

I am working on a worksheet, and I have a little problem, it is not that
important, but it is part of the worksheet. I am using the function
WEEKDAY(C8,1). If I put this date: 8/1/2006 in cell C8, it returns "3",
which
is correct so far. However, when I integrate the function WEEKDAY() in the
function IF() (see below):


=IF(WEEKDAY(C8,1)="1","Zondag",IF(WEEKDAY(C8,1)="2 ","Maandag",IF(WEEKDAY(C8,
1)="3","Dinsdag",IF(WEEKDAY(C8,1)="4","Woensdag",I F(WEEKDAY(C8,1)="5","Donde
rdag",IF(WEEKDAY(C8,1)="6","Vrijdag",IF(WEEKDAY(C8 ,1)="6","Zaterdag","")))))
))

Language=Dutch for the days, sorry about that:)

So the problem is, when I use this formula, it returns the last
VALUE_IF_FALSE, which is "", that gives me an empty cell. It is only
supposed
to give an empty cell if all the previous statements are False, and that
is
not supposed to be the case here.
If I put 8/1/2006 in cell C8, I want to see "Dinsdag". Sorry for my
incoherent story, hope you understand my problem!