Probably because XL doesn't recognize it as a date. It
just interprets it as a text string. If you just enter:

April 1, 2005

then XL will recognize it as a date.

To convert your current text string to a legitimate date,
use:

=--MID(G1,FIND(" ",G1)+1,1024)

and then format the date however you want.

HTH
Jason
Atlanta, GA

-----Original Message-----
Why does Friday, April 1, 2005 in a date formated cell
generate a wrong data
type error when using the WEEKDAY formula?
.