Thread: How do I find the length of time (Years & Months) between 2 dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brandon
 
Posts: n/a
Default How do I find the length of time (Years & Months) between 2 da
I have a spreadsheet with a date inducted and a date it needs to be replaced.
How do I get a cell with the remaining days between the dates and it update
daily?

"Ardus Petus" wrote:

=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