Try

=DATEVALUE(B1)-DATEVALUE(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Benny" wrote in message
...
Hello, I need to count the number of days between dates also the months
are
in spelled out. I can't change them to numbers. So, is there a way to
count
days if cell A1 is Sep/5/2008 and cell B1 is Oct/25/2009?