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
Bookmarks