View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
punkrawk_99 punkrawk_99 is offline
external usenet poster
 
Posts: 1
Default Calculate age with an end date

I am currently using the formula =DATEDIF(J5,TODAY(),"y")&" years
"&DATEDIF(J5,TODAY(),"ym")&" months "&DATEDIF(J5,TODAY(),"md")&" days" to
calculate the length of time I have a cigar in a humidor. The start date is
in column J and the age displays in column K. What do I need to add so that
when I put an end date in column L (the date the cigar is smoked), the age
displays just the length of time between the dates?