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: 
One way to do so... maybe not best since it involves adding so many rows

Add a fresh column D and E if not available..

Then use Text to Columns on Column C, with space as delimiter... (This will split column on spaces into 3 columns)

Add a new Column D with formula 

```
=MONTH(C3&1)

```

Make sure new Column D is of type General or Number rather than Date

Then you can use the following formula

```
=DATE(F3,D3,E3)

```
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.