Thread: How do I find the length of time (Years & Months) between 2 dates
View Single Post
  #5   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 da
=DATEDIF(date1, date2,"d") for days between date1 & date2

HTH
--
AP

"Brandon" a écrit dans le message de
...
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