| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Question Formula Negation
Formula Negation
How do I skip a formula, if left of cell does not equal a colon, followed by 7 numbers? thanks. e.g.: date yymmdd :060120 e.g.: IF(LEFT(T9,7)= ??(:0000000),then do formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Date Question | Excel Discussion (Misc queries) | |||
| Reference question | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Cell / Date Formatting Question when result = -0- | Excel Discussion (Misc queries) | |||
Hybrid Mode
