Column of Dates with ( ) - delete ( )?

  • Thread starter Thread starter Doug Boddicker
  • Start date Start date
D

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
 
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
 
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
 
Hi.

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

Alain CROS.
 
Back
Top