Hi,

Try this:

=DATEDIF(A1,TODAY(),"d")