Not sure what you want with MM/DD/yyyy
Is the MM for January "JA or 01," but if you change the "MID" numbers
you can get anything you want.
Example: If cell A1 has January and you want to see Jan in Cell B1
using the MID Function
it would be MID(B5,1,3), it reads as follows: B5 is the Cell, 1 is the
position of the first character you want to read, 3 is how many.
Just "play around" with the set of numbers following the MID and it
will give you an idea of how it works.
=CONCATENATE(MID(B5,1,6),MID(D5,7,4)+5)
B______________D____________F
Birth date________Issue Date____Expires
05/01/1947_______06/20/2005_____05/01/2010

For the AB, BD, and CF... - you can create a "AND" statement in a
Cell say "G" which will give you a TRUE or False and would look
something like:
=AND(A1B1,B1D1,C1F1)


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=505234