+ Reply to Thread
Results 1 to 2 of 2

Calculating Month and days betweens dates

  1. #1
    Registered User
    Join Date
    10-30-2007
    Location
    Mumbai
    Posts
    13

    Calculating Month and days betweens dates

    How to calculate numbers of month and days betweens dates
    what i found is really goods to my knowledge but i want more specific
    for eaxmple

    Earlier Date is 15-June-2006

    Later Date is 14-September-2007

    its comes to 456 days

    but how to calculate how many months and days

    please help

    Regards

    Deepak

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    hello deepak,

    If the earlier date is in A1 and later date in B1 then use this formula to give the difference in months and days

    =DATEDIF(A1,B1,"m")&" months "&DATEDIF(A1,B1,"md")&" days"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1