Date format changed to text format

I would like to use the function offered to me below. In cell C2 I enter my date as text, 11/27/2013, In cells A3:A16 I have dates also formatted as text, same as in C2. Cell D3 holds the product number also formatted as text. The same formatting also applies to B3:B16, text.


The result is #VALUE error.
Frank FreeseAsked:
Who is Participating?
Angelp1ayConnect With a Mentor Commented:
Also I think you need a DateValue around your range in col A:

Open in new window

Is this literally just because your date is in C2 but your formula is actually referencing D2?
Frank FreeseAuthor Commented:
Great job! You nailed it there....
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.