For the following formula format your cells as follows:
Column A - Birthdate - Format as Text
Column B - Issue Date - Format as Text
Column C - Is the Experiation Date - Format as General (or the formual
will not work if it is formated as "Text" - don't need to use the date
function).
In column C - use the following formula:
=CONCATENATE(MID(A2,1,6),MID(B2,7,2)+5)
A______________B____________C
Birth date______Issue Date____Expires
05/01/47_______06/20/05_____05/01/10

If you want to "add" more "time" to the expire date - just change "+5"


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