+ Reply to Thread
Results 1 to 3 of 3

Cumulative months between dates

  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cumulative months between dates

    Here's a tricky one.

    I have three columns: A, B, C

    A is a start date
    B is an end date
    C is the date in which a certain number of months has been reached.

    For example:

    A1) 1-22-90
    B1) 6-29-96
    C1) Date in which 53 months has been reached.

    I need to find three different "checks point" - 96 mo, 120 mo, 144 mo.

    "What is the date in which 96 months has been reached when adding number of months between a series of separate dates"

    something like that. Does this make sense? I appreciate any help I can get! Thanks!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Cumulative months between dates

    So what is the value of C1 using your example...I'm confused... are you trying to add 53 months to B1 ?

    =EDATE(B1,53)

    (EDATE is available via the Analysis ToolPak - see Tools -> Addins)

  3. #3
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Re: Cumulative months between dates

    EDate example
    Attached Files Attached Files
    Last edited by Dunc3142; 02-19-2009 at 03:37 PM.
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

+ 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