One way ..
Assuming A1 houses a real date,
Try it in B1 as: = --"30/09/2006"-A1
Format B1 as general or number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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