View Single Post
  #1   Report Post  
Hari
 
Posts: n/a
Default Calculating Date difference in 2 ways

Hi,

If in cell A1 I write -- = today() - date(2004,12,31)
then the answer I get is a number ( let's say 14 or 15)

But if in cell B1 If i write -- = C1 - D1
where C1 -- = Today() and D1 -- = date(2004,12,31), the answer I get is
in date format (in excel's 1900 base year)

Why is there a diference in formatting of results between the above 2
approaches.

Regards,
Hari
India