Results 1 to 3 of 3

Thread: EOMONTH Formula

  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    EOMONTH Formula

    Is this formula available in Excel 97 or earlier versions? How about the =Year formula.

    I have set up a spreadsheet for a client (I'm using Excel 2000 SR-2) and she getting errors in the fields where I have these formulas when she runs it on her machine. It works just fine on my machine.

    Thanks in advance,

    Christa

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: EOMONTH Formula

    You need to have the Analysis ToolPak AddIn activated to use those function. Goto Tools, Add-Ins, and browse through the list until you find it (it should be near the top), make sure it is selected. If you cannot find it there you will have to install it from your Office Installation media.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EOMONTH Formula

    Thank you! You're a life saver <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

Posting Permissions

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