Formula reads date as number

  • Thread starter Thread starter pete5761
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

accepting most recent date across columns 10
Formula syntax 8
How do I reference a cell as a row number in a formula? 4
Formula Help 4
copy date in a cell if within a date range 1
If Question 4
Adding a number with a formula 2
COUNTIFS BETWEEN WORKSHEETS HELP 1

Back
Top