Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mmonth calculator (2000 sr-1)

    I want tocalculate the difference from C2-F1 and insert total of number of month in D2, but only the year is in range G1:K1...
    example:
    26/03/1944 - 2007 = 63 , ok calculate month in D2

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mmonth calculator (2000 sr-1)

    Try

    =IF(ISNUMBER(MATCH(DATEDIF(C2,$F$1,"y"),$G$1:$K$1, 0)),DATEDIF(C2,$F$1,"m"),"")

    See attached version.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mmonth calculator (2000 sr-1)

    WORK!
    But is possible to make dinamicly the date in F1 in this format: 31/12/current year...
    example if today is 2008 automaticly 31/12/2008...
    Hope understand me:-)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mmonth calculator (2000 sr-1)

    Use this formula in F1:

    =DATE(YEAR(TODAY()),12,31)

    See attached version.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mmonth calculator (2000 sr-1)

    sUPER!!!!!!!!!!

Posting Permissions

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