Show weekday as text

[paulvanrijn]

i used a code

Please Login or Register  to view this content.

, whene i placed a date in cell E11 excel placed the day in the cell like ( monday, Tuesday ect. ) but whene i don't place any date in cel E11 , automatic excel will placed "Saturday" in the cell.

is there a short code that the cell will be empty whene i don't used a date

Sorry for my stone coal english


thanks

paul

[CRIMEDOG]

=if(E11<>"",TEKST(WEEKDAG(E11);"DDDD"),"")

[paulvanrijn]

Sorry , CRIMEDOG, but there will be a pop-up notification with the text " The formula you typed contains an error "


but thanks for thinking anyway

[xlnitwit]

Hi,

You need only use semicolons in CRIMEDOG's formula

=if(E11<>"";TEKST(WEEKDAG(E11);"DDDD");"")

[paulvanrijn]

i get "#Name - Error: Invalid name" in the cell whene i used the code

Please Login or Register  to view this content.

[paulvanrijn]

Hey i have the problem solved . I have to write the code in DUTCH , so i don't must start with IF but ALS .

Thank you for thinking

[xlnitwit]

I am attaching a workbook which should adjust to match your language and formula settings when you open it. I have removed the WEEKDAG part as I saw no need for it here.

[xlnitwit]

Hey i have the problem solved . I have to write the code in DUTCH , so i don't must start with IF but ALS .

Ah yes- of course. Thank you for letting us know.