Why is Saturday showing up in cells when there's no date present using the TEXT function?

Hello everyone,

I've been trying to figure this out for the past two days and it's driving me nuts so I'd greatly appreciate any help with this.

I'm updating a vacation request form so that when someone types in the date (1/22/14 for example) in column C(D) the corresponding day of the week will automatically pop up in column E(FG). I used the following formula: =TEXT(C13, "dddd") but here's where the problem comes in. Some of the rows in the E column are blank (because there's no date typed in column C) but others say "Saturday" and there's no corresponding date to go with it. I want E13-E21 to remain blank until someone puts a date into the corresponding cell (C13-C21). Is there anyway to fix this? I've attached a picture as well.

Thanks for any help with this!

OK, thanks for responding. How do I fix this? As I stated above I'd like the columns to remain blank until someone enters a date.

Thanks

martindwilson I apologize as I didn't see your solution the first time I only saw this "because the cells contain 0 or blank and excel thinks that it is 0/jan/1900 which although doesnt exist is a saturday
TEXT(C13, "dddd") if c13 is blank is 0".

But I'd like to thank you and Tony Valko so so much because the problem is solved.

Thank you so so much!!