Another way to convert text "dates" to real dates (if the dates are in a single
column).

Select the column
data|text to columns
fixed width
(remove any lines excel guessed)
choose the correct format to match the values in the cell mdy, dmy, ...

Then finish up and format the cells the way you like (dmy maybe??).

Another way if your windows regional date setting matches the same order as the
text dates.
select the range
edit|replace
what: /
with: /
replace all

Excel will see that you're reentering the values and notice that they're dates.

Don't do this if the windows regional date setting isn't the same order as the
text values.

Charlotte Howard wrote:

Hi,

I have extracted date information from various different databases and wish
to determine which are greater than a certain date. Now, I can write the IF
statement (IF(G2J1,True,False), but it doesn't seem to be working correctly,
it gives all dates as True, even when they are less than my cutoff date.

I think that there could be a problem with my imported dates, but I cannot
convert them using DATEVALUE - some convert, some give the #VALUE error.
If I convert using =TEXT(G2,"dd/mm/yyyy"), I still can't either work the IF
statement, or use DATEVALUE!

A problem is I'm not sure exactly how the date info is held in the databases,

Help, I think I'm going mad.....

Charlotte

--

Dave Peterson