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.

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))


On Sat, 13 Nov 2004 03:21:33 GMT, "adropinabucket" wrote:

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.

Many thanks for your help.



"Myrna Larson" wrote in message
...
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))


On Sat, 13 Nov 2004 03:21:33 GMT, "adropinabucket"
wrote:

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.