Thread: How do I find the length of time (Years & Months) between 2 dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default How do I find the length of time (Years & Months) between 2 dates
=DATEDIF(date1, date2,"y") for years
=DATEDIF(date1, date2, "ym") for extra months

HTH
--
AP


"David Picken" <David a écrit dans le
message de ...



Reply With QuoteReply With Quote