Excel Date Display?
Hello
Let's Suppose i gave some date 01-01-2007 in cell A1 and 01-05-2010 in cell b1
if i Subtract Cell B1 from A1 so the Answer will be 1100 Days BUT
i want these days as date like 6 days 1 months and 3 Years
OR
01/06/03
Is it Possible ?
Please Help
|