Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    How Many Months (Excel 2002)

    Hi

    In Cell C2 I have the date 01/04/2004 in Cell M2 I would like to show how many months have elapsed betwee C2 and 31/12/2004 ie 8

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: How Many Months (Excel 2002)

    Hi

    Sorry to waste your time I worked it out for myself as below

    =IF(ISERROR(MONTH($O$1)-MONTH(C2)),,MONTH($O$1)-MONTH(C2))

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: How Many Months (Excel 2002)

    You can also use DateDif:
    <pre>=DATEDIF(C2,$O$1,"m")</pre>


    Steve

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: How Many Months (Excel 2002)

    Hi Steve

    Your method is a bit shorter.

    Thanks for the reply.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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