Hi, found Answer, thought you might like:
If you format the cell with the date expression that works in to show
the year as 4 figures you will see it is 1906 not 2006 as you probably
think, the logic works but the date is not the date you think it is, if
in the year bit of the formula you add +100 it should work as you want

=IF(TODAY()DATE(MID(C4,2,2)+100,MID(C4,4,2),MID(C 4,6,
2)-$A$4),"yes","no")

"Govind" wrote:

Hi,

Use

=DATE(MID(A1,6,2),MID(A1,4,2),MID(A1,2,2)+5)

where A1 has the number and text. I have assumed that the number
position is exactly as you described. The formula might change if not.

Regards

Govind.

nastech wrote:
Hi, trying to find a number within text, to do a calculation on it. Item is as:
:060101 at the left of a cell, with text following.

(if can treat as a date in another cell: to add/subtract 5 days, would be
the 2nd question).

thanks