Hi,

Put 30/09/2006 in Cell A2. Put the formula =A2-A1+1 in Cell A3 and format
the cell as number.

Regards,

Jaleel

"ShamsulZ" wrote:

Say cell A1 the date is '01/09/2006' and i want to know how many days there
are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help with
the correct formula. thanks friends