+ Reply to Thread
Results 1 to 4 of 4

How to count # of Month between two period

  1. #1
    Registered User
    Join Date
    05-09-2005
    Posts
    2

    How to count # of Month between two period

    Hello,

    It is my first time to post but I used your forum in numerous instances. After searching the forum, I did not find the answer to my question which should be quite simple.

    What formula could I use in order to have the # of months between two periods?

    For example, I would like my cell C1 to show me the # of months (for this example, "C1" would be 28.

    A B C
    1 01/01/2002 1/05/2005 =# of months

    Thanks in advance,

    David

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Here's a solution: http://www.cpearson.com/excel/datedif.htm
    The DATEDIF(...) function is a function with a very special history

    Hope it helped
    Ola Sandström
    Last edited by olasa; 05-09-2005 at 05:45 PM.

  3. #3
    Registered User
    Join Date
    05-09-2005
    Posts
    2

    Thanks

    Thanks a lot, you solve my problem.

    It is really appreciated.

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    You're welcome...and thanks for the feedback
    Ola Sandström

+ 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