Results 1 to 3 of 3

EDATE formula works on one computer, not on another

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2009
    Location
    Lousiana, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    EDATE formula works on one computer, not on another

    We have a problem in the office that we can not figure out.

    One worksheet, when opened on one computer works fine. When opened on another computer, an if statement with an EDATE function gives a NAME? error.
    When I evaluate the error (Show Calculation Steps...) here is what is returned:
    IF(40402, EDATE(D69, 1), "")
    IF (TRUE, #NAME?,"")

    There is definitely a date in D69 (as it serializes in the calculation steps). Just tested on a third, and it works fin on that one also.

    I have no idea why this is happening. Any ideas?
    Last edited by teylyn; 08-12-2010 at 08:30 PM. Reason: restored original post

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