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(WEEK DAY(C8,1)="4","Woensdag",IF(WEEKDAY(C8,1)="5","Don derdag",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!