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!
Bookmarks