Formula reads date as number

P

pete5761

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

Any hel
 
N

Niek Otten

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.
 
Top