Hi.. Thanks for the input. Can we change the cells to read AB, BD, and
CF...
I require that the birthdate cell (B5) be MM/dd/yy format, "October 01,
1947". Could another cell (ie; B10) read (B5), and then B10 is used in the
formula?
I would really prefer to have the results printed as MM/dd/yyyy in F5. Can
we do the calculation elsewhere and read/copy the result back t o F5?

"wjohnson" wrote:


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