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.