Results 1 to 3 of 3

Thread: Date Difference

  1. #1
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007

    Post Date Difference



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    following example given below for calculating period between two date difference.

    YYYY MM DAY
    2014 10 14
    2012 12 27
    Ans: 1 09 17


    what formula to apply to get the above Answer.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Assuming dates are in A1 and A2, try:

    =DATEDIF(A2,A1,"y")&" "&DATEDIF(A2,A1,"ym")&" "&DATEDIF(A2,A1,"md")


  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Sir,
    Many Many thanks for resolve the issue.


    Regards,
    sambit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •