software

=DATEVALUE(quot;7/1/20quot;amp;MID(C3,13,2)) creates error.

Automatic Error Checking reports this as a quot;Text date with 2 digit Yearsquot;.
Formula otherwise works.

BTW - c3=quot;School Year 06-07quot;

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

This didn't get flagged:

=DATE(quot;20quot;amp;MID(C3,13,2),7,1)Gary wrote:
gt;
gt; =DATEVALUE(quot;7/1/20quot;amp;MID(C3,13,2)) creates error.
gt;
gt; Automatic Error Checking reports this as a quot;Text date with 2 digit Yearsquot;.
gt; Formula otherwise works.
gt;
gt; BTW - c3=quot;School Year 06-07quot;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions

--

Dave Peterson