Thread: Date matter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ShamsulZ ShamsulZ is offline
external usenet poster
 
Posts: 23
Default Date matter

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