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


--
pete5761
------------------------------------------------------------------------
pete5761's Profile: http://www.excelforum.com/member.php...o&userid=29610
View this thread: http://www.excelforum.com/showthread...hreadid=494237

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" wrote in
message ...

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