Thread: Date Count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SgMike SgMike is offline
external usenet poster
 
Posts: 1
Default Date Count

Hi all ...

I would like to know if Excel can count the number of Years and Months for a
duration (E.g from 1 Jan 2005 to 1 Dec 2006). With a formula set, it gives
you the answer as 1 Year 11 months.