Thread: Formula reads date as number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pete5761
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote