What is xdate? I don't know that function, it must be a UDF.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nannie" wrote in message
...
They are formatted as dates but most were entered as
=xdate(1860,6,11,"yyyy,
mm dd") although some look like ~1862 or after 1862. They are civil war
era
dates and Excel can't handle them. (Seems strange Excel doesn't have the
choice of displaying dates with years first.)

Thanks for any assistance!
--
Nannie


"Bob Phillips" wrote:

Are they text fields or real dates just formatted in different ways?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Nannie" wrote in message
...
I have a column of dates in various formats (sometimes the year is
first,
sometimes not). I would like to determine the number of times a
specific
four-digit year occurs withing the column. Can you help me? Thanks!
--
Nannie