Hi

Just take the earlier data away from the later date.
="10/31/2006"-"10/20/2006"
or with dates in A1 10/20/2006 and B1 10/31/2006
=B1-A1

Add 1 to the result if you want to include the whole of the 20th and the
whole of the 31st.
Format the cell with your formula as FormatCellsGeneral.

--
Regards

Roger Govier


"Nad" wrote in message
...
Hi,
How can i find the duration (No. of days) between two days.

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

Thx & Regards,