Column of Dates with ( ) - delete ( )?

[Doug Boddicker]

I have a database dump that has two columns of dates; 1 is
normal format mm/dd/yy and the other column is (mm/dd/yy).
I'm trying to use the =Days360 function, which counts the
# of days between the two date columns. But this function
does NOT like the ( ) and fails. If I remove the ( ) all
is fine. But my column of dates is very long and I don't
have time to edit each field so the ( ) are gone. Is
there a quick, easy way of removing the ( ) in a long
column of dates? Any suggestion will be appreciated and
considered.
Thanks, DAB

 

[Tim Otero]

Highlight the column, then go to Edit>Replace, under "Find what:" put the
left paren and leave the "Replace with:" blank. Repeat process with right
paren.

tim

 

[Lance]

The easiest way is to do an edit|replace on the "(" and
then the ")", each time place no value in the replace with
box
Lance

Make sure you backup first

Lance

 

[Alain CROS]

Hi.

Good date in A5 and Bad date in B5
=DAYS360(A5,DATEVALUE(SUBSTITUTE(SUBSTITUTE(B5,"(",""),")","")))

Alain CROS.