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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>