Formula #value! Error,
thankyou, will look at later, i'm just novic, but mother necessity:
=IF(LEFT(T9,2)<":0","",IF(AND(MIN(AK9:AO9)<1,LEFT (T9,1)=":",TODAY()DATE(MID(T9,2,2)+100,MID(T9,4,2 ),MID(T9,6,2)-$H$7)),"dd"))
"pinmaster" wrote:
Try:
=IF(TODAY()=DATE(MID(T9,2,2)+100,MID(T9,4,2),IF(I SERROR(MID(T9,6,2)-$H$7),1,MID(T9,6,2)-$H7)),dd",
if no day in text then 1....first of month
HTH
JG
"nastech" wrote:
Got this far, don't know how to negate #Value! error, in equation: (thanks)
=IF(TODAY()=DATE(MID(T9,2,2)+100,MID(T9,4,2),MID( T9,6,2)-$H$7)),"dd",
to do with, if not have :yymmdd in left of general text cell T9... or even
if the dd portion is not present.
|