Question: I have dates within a cell using this format: (February 13 2014).

When I try to use "WEEKDAY(C2)" I get #VALUE!

I have no idea how to fix this and I need some help to finish this web scraping project. Any ideas?

Answer: 
Formula only: 

```
=WEEKDAY(DATE(RIGHT(C2,4),MONTH(LEFT(C2,FIND(" ",C2)-1)&1),(MID(C2,FIND(" ",C2)+1,2))))  

```

with thanks to @tgeery.
Your dates are not in the correct format.

```
WEEKDAY(DATE(2014,2,13)) 

```

should work because the argument for the weekday function needs to come from the DATE function.