That was Great!! Thanks, been trying to figure that out for awhile,
if I can ask, first: think you had values reversed, as I made work:
=DATE(MID(A1,2,2),MID(A1,4,2),MID(A1,6,2)+5)

verify will show if within 5 days, right? but how do I put in equation to
make use of
trying:
=IF(DATE(MID(C6,2,6)DATE(MID(C6,2,2),MID(C6,4,2), MID(C6,6,2)+5,"Y","N")

does not quite work, am I missing a parenthesis? comma.. thanks..


"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