Weekday default to blank and not Saturday?

[Legs]

I am using the formula
=TEXT(WEEKDAY(B2), "dddd")
If B2 is blank the cell defaults to say “Saturday” Is there any way to change this so it defaults to “Blank” or ideally shows nothing at all if B2 is empty?

[EEL1966]

What about this

Please Login or Register  to view this content.

[Legs]

That’s fantastic thank you! I was trying to get this to work for ages:
=IF(B1="", "", "=TEXT(WEEKDAY(B1), "ddd")")
I was so close!

How would I get this to apply to every row in say column A to to work with the relevant cell in column B? For example place the code in A2 and have it pick up the nput from B2, and A3 – B3, A4 – B4 ect?

[EEL1966]

If you have formula in A2 and you have activated A2 you should see a small black square in the right lower corner. Select that small square and drag it down. Then the formula should then be dragged down.

[Legs]

That is fantastic, thank you!