Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text / formula help
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") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text to formula - Help pleaaase | Excel Discussion (Misc queries) | |||
text in formula explaining formula not to print | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |