View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Naveeddil Naveeddil is offline
external usenet poster
 
Posts: 1
Default 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