From your original post, put this formula in c1:

=ABS(VALUE(A1)-VALUE(B1))

and format c1 as general. It will return 2646 which is the number of
days between the two dates.

Clioff Edwards