G
Guest
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",IF(WEEKDAY(C8,1)="5","Donderdag",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!
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",IF(WEEKDAY(C8,1)="5","Donderdag",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!