Hi

Either use
=DATE(2006,9,30)-A1
or
=--"30/09/2006"-A1
the double unary minus -- forces the text value to be a date value.

--
Regards

Roger Govier


"ShamsulZ" wrote in message
...
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