There is also an "undocumented" formula:
=DATEDIF(A1,B1,"d")


"Nad" wrote:

Hi,
How can i find the duration (No. of days) between two days.

ex. (10/20/2006 to 10/31/2006)

Thx & Regards,