routine to convert to date format

[adropinabucket]

I have a worksheet that contains dates.

The dates have been entered in general format.

For the month of November (2004) they are, (for example)

Sun 7, Mon 8, Tues 9, Wed 10, Thurs 11, Fri 12, Sat 13.



I would like to convert these text entries to the appropriate date number.



So Sun 7 would become 38298, formatted as ddd d.

 

[Myrna Larson]

In a helper column, assuming the 1st date is in A2, you would use a formula
like this

=DATE(2004,11,MID(A2,FIND(" ",A2)+1,2))

 

[adropinabucket]

Many thanks for your help.

In a helper column, assuming the 1st date is in A2, you would use a
formula
like this

=DATE(2004,11,MID(A2,FIND(" ",A2)+1,2))