Thread: How do I calculate exact difference between two dates in y,m,d.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
  
Posts: 256
Default How do I calculate exact difference between two dates in y,m,d.
Correction...

=DATEDIF(A2,B2,"yd")

should be

=DATEDIF(A2,B2,"md")

Hope this helps!

In article ,
Domenic wrote:

Assuming that A2 contains the first date, and B2 contains the second,
try...

=DATEDIF(A2,B2,"y")

=DATEDIF(A2,B2,"ym")

=DATEDIF(A2,B2,"yd")

Hope this helps!
Reply With QuoteReply With Quote