text / formula help
Ok. great.Happy to help
Govind.
nastech wrote:
Think I have it.. sorry for the repeat/ sloppy formula, something like:
salute.
=IF(TODAY()DATE(MID(C6,2,2),MID(C6,4,2),MID(C6,6, 2)+5),"yES")
"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
|