Convert string to date

[farrukh]

Hi All

i want to convert string to date, currently i have the date in string format.

oct,2009
dec,2009 and so on. I want this string convert to date format.

Thanks
farrukh

[duthiet]

Farrakh:

To have a date formula you will need the following numbers
1. Year Month Day

Using a simple Vlookup table and assuming the day is always 1 the attached will convert the above string to a serial date.

Hope this helps,

Tom Duthie

[sdckapr]

It can be done without a lookup by using a formula like:
=DATEVALUE(SUBSTITUTE(A1,","," 1, "))

This will make the date the first of the month. You can change the "1" to whatever day of the month desired.

Steve

[farrukh]

Hi duthiet and Steve,

Thank you so much for your kindness great

Thanks
farrukh