Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Question
Hi, Can't do yymmdd in a spread sheet ??? please give actual example,
=IF(ISERROR(Formula_To_Evaluate),ErrorValue,Formul a_To_Evaluate) leaves so many questions, don't know where to start... every tick mark missed = missed understanding.. "IF" included in (formula to to eval), front and back? what is error value, type "error value"????? is error value something it parrots back to you saying it isn't going to work?... got more There has to be a way to skip equation, for no error for some condition, just can't find that condition / equation prefix, e.g.: IF(LEFT(T9,1)=":",... then perform equation, but if date out of range, get false, but equation not letting me put: IF(T9="","" has to be a simple way to skip equation trying to use a general format cell that has text following a date, to read date & perform a function on it, without errors. So far have: =IF(LEFT(T9,1)=":",IF(AND(MIN(AK109:AO9)<1,TODAY() DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd")) $H$7=5, and date 060220 gets false condition, havent been able to negate for a cell that would have a date like: :yymmdd (as in: 060220) followed by text will perform the task, but does a false, if condition not met. (or VALUE error if equation is changed), have other functions to add after this equation, for more tasks to perform. All these errors, where's the programmers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Question
If cell A1 contains this text 26/01/06 Robert if(mid(A1,3,1)="/",do something,do something else) will allow you to take action if your cell contains a date in front of any text. I assume you have other questions, if you are more specific I am sure someone will help you. The iserror function returns numbers for the different types of error. hope this helps -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=502830 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Question
It might help if you gave a few sample of your data, and explain what kind of
calculation you want do do and the result you expect. Regards JG "nastech" wrote: Hi, Can't do yymmdd in a spread sheet ??? please give actual example, =IF(ISERROR(Formula_To_Evaluate),ErrorValue,Formul a_To_Evaluate) leaves so many questions, don't know where to start... every tick mark missed = missed understanding.. "IF" included in (formula to to eval), front and back? what is error value, type "error value"????? is error value something it parrots back to you saying it isn't going to work?... got more There has to be a way to skip equation, for no error for some condition, just can't find that condition / equation prefix, e.g.: IF(LEFT(T9,1)=":",... then perform equation, but if date out of range, get false, but equation not letting me put: IF(T9="","" has to be a simple way to skip equation trying to use a general format cell that has text following a date, to read date & perform a function on it, without errors. So far have: =IF(LEFT(T9,1)=":",IF(AND(MIN(AK109:AO9)<1,TODAY() DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd")) $H$7=5, and date 060220 gets false condition, havent been able to negate for a cell that would have a date like: :yymmdd (as in: 060220) followed by text will perform the task, but does a false, if condition not met. (or VALUE error if equation is changed), have other functions to add after this equation, for more tasks to perform. All these errors, where's the programmers. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Question
Hi, yes, sorry for long question, trying to fix at 3 in the morning..
hope I give the right items: cell with general format, text date? in form of :yymmdd (is proceeded with a colon so if format drops would not loose proceeding zero). (yymmdd needed to quick view/enter dates, sorting / visual scan many records..) :yymmdd followed by word text... :060122 text then written... $H$7 has 5 for 5 days =IF(LEFT(T9,1)=":",IF(AND(TODAY()DATE(MID(T9,2,2) +100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd"),IF(BE9="T","dn",IF(BF9="T","up",IF(AK 9<"","ck","")))) if use :060122 get correct dd response if use :060130 get FALSE response, and rest of equation will not work. if use : (no date) followed by text, get VALUE error If I use the following equation: =IF(LEFT(T9,1)<":",IF(AND(TODAY()DATE(MID(T9,2,2 )+100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd"),IF(BE9="T","dn",IF(BF9="T","up",IF(AK 9<"","ck","")))) Rest of formula works, TODAY/DATE does not. My best guesse I need to find an Exclusion that lets skip IF(AND(TODAY... so it will not even look at it, items not to familiar with.. like text search: if 1st 7 characters not equal :###### (colon 7 numbers, maybe a space) I see the front part of my equation, as being incorrect: =IF(LEFT(T9,1)<":", Thanks in advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Question
correction update: formula works, within date works,
get FALSE if date in future of (5 days..); need to know how to make skip false.. "pinmaster" wrote: It might help if you gave a few sample of your data, and explain what kind of calculation you want do do and the result you expect. Regards JG "nastech" wrote: Hi, Can't do yymmdd in a spread sheet ??? please give actual example, =IF(ISERROR(Formula_To_Evaluate),ErrorValue,Formul a_To_Evaluate) leaves so many questions, don't know where to start... every tick mark missed = missed understanding.. "IF" included in (formula to to eval), front and back? what is error value, type "error value"????? is error value something it parrots back to you saying it isn't going to work?... got more There has to be a way to skip equation, for no error for some condition, just can't find that condition / equation prefix, e.g.: IF(LEFT(T9,1)=":",... then perform equation, but if date out of range, get false, but equation not letting me put: IF(T9="","" has to be a simple way to skip equation trying to use a general format cell that has text following a date, to read date & perform a function on it, without errors. So far have: =IF(LEFT(T9,1)=":",IF(AND(MIN(AK109:AO9)<1,TODAY() DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T9,6,2)-$H$7)),"dd")) $H$7=5, and date 060220 gets false condition, havent been able to negate for a cell that would have a date like: :yymmdd (as in: 060220) followed by text will perform the task, but does a false, if condition not met. (or VALUE error if equation is changed), have other functions to add after this equation, for more tasks to perform. All these errors, where's the programmers. |
#6
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) |