=TODAY()DATE(MID(C4,2,2),MID(C4,4,2),MID(C4,6,2)-$A$4) will reveal if you
are actually comparing dates.If you dont get true when you know you should
then excel isnt seeing the numbers/dates/text as you think!

paul
remove nospam for email addy!



"nastech" wrote:

cannot get the following equation to work, is it wrong?
only way to get to switch TRUE to FALSE, is to flip to <; Changing the
days in A4 having no effect.

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

details:
am trying to find a number within text, to do a calculation on it. Item is as:
:060120 at the left of a cell, with text following.

(need to treat as a date in another cell: to See if within future range of
x days)
A4 has: 5
B4 has: =TODAY()
C4 has:
:060122

D4 has:
=DATE(MID(C4,2,2),MID(C4,4,2),MID(C4,6,2)-$A$4) seems to work

not working:
=IF(TODAY()DATE(MID(C4,2,2),MID(C4,4,2),MID(C4,6, 2)-$A$4),"yes","no")