You need to convert the text format to real dates first.

How do the text dates look like

--


Regards,


Peo Sjoblom

"David" wrote in message
...
I try to count the # of days in each row between two columns but each field
has different format. Some cells are in Date Format and some are in Text
format. How can I setup a formula to count the number of days? I got the
#NUM! when I used =DATEDIF(A1,B1,"D")+1.