Text to columns is the simplest way to replace the text with dates.
Highlight your column and use:

DataText to ColumnsNextNextDateMDYFinish

Regards,
Fred.

"Justin" wrote in message
...
Thanks Fred and Bernard. My dates are text and not excel dates. Is there a
way to change the text to date. This is the form they are in the cells
03/24/1975 (mm,dd,yyyy)

Justin

"Bernard Liengme" wrote:

Which suggest you do not have real dates in the cells. What happens if
you
type (in any blank cell) =B1+1 ? Do you see B1' s date incremented by one
(ie the next day?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Justin" wrote in message
...
So far none of these have worked.

"Brad" wrote:

since you are concerned about days
=b1-a1 will work

I find that datedif is more efficient when dealing with months or
years....
--
Wag more, bark less


"Justin" wrote:

I just want to be able to count days between two dates. I am using
excel 2003.

example
a1 12/5/1999 b1 03/04/2007
if i want the number of days between a1 and b1 in c1, what should
the
formula read? What format should each of the cells be in?