Thread: Date calculation in Excel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Date calculation in Excel 2003
Hi,

If your dates are in cell A1 and B1 :
=DATEDIF(A1,B1,"Y")&" "&DATEDIF(A1,B1,"D")-365

HTH
Cheers
Carim

Reply With QuoteReply With Quote