+ Reply to Thread
Results 1 to 2 of 2

Formula reads date as number

  1. #1
    Registered User
    Join Date
    12-13-2005
    Posts
    2

    Exclamation Formula reads date as number

    I have a formula that reads a list of dates in cells K5 through K20 and compares these dates to 1 date in cell M3. Cell M3 shows a date but when I run the evaluate formula auditing tool on the formula, M3 dates shows as a number, thus the formula fails.

    Any help

  2. #2
    Niek Otten
    Guest

    Re: Formula reads date as number

    Dates are stored as number of days since 1-1-1900. So today (dec 16,2005) is
    stored as 38702.
    That's the value you see in the formula evaluator, not how it was formatted.

    --
    Kind regards,

    Niek Otten

    "pete5761" <pete5761.205fyy_1134764101.9245@excelforum-nospam.com> wrote in
    message news:pete5761.205fyy_1134764101.9245@excelforum-nospam.com...
    >
    > I have a formula that reads a list of dates in cells K5 through K20 and
    > compares these dates to 1 date in cell M3. Cell M3 shows a date but
    > when I run the evaluate formula auditing tool on the formula, M3 dates
    > shows as a number, thus the formula fails.
    >
    > Any help
    >
    >
    > --
    > pete5761
    > ------------------------------------------------------------------------
    > pete5761's Profile:
    > http://www.excelforum.com/member.php...o&userid=29610
    > View this thread: http://www.excelforum.com/showthread...hreadid=494237
    >




+ 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