Partial lookup in one column, return text in another column

[tektools]

I need a formula that if a date (with a name) in one cell, depending on the date, returns the day of the week to the adjacent cell. There are only two dates. I'm pretty sure it would have a VLOOKUP with wild cards.. but I have no idea where to start.

[bebo021999]

B1:

Please Login or Register  to view this content.

[kvsrinivasamurthy]

If default date format is mm/dd/yyyy

Please Login or Register  to view this content.

If default date format is dd/mm/yyyy

Please Login or Register  to view this content.

[Bo_Ry]

for US region date format setting with M/d/yy
Please try

=TEXT(LEFT(A1,FIND(" ",A1)),"ddd")