If(isnumber(search) help

DUSTWUN

New member
Joined
May 17, 2019
Messages
8
Reaction score
0
Points
0
Excel Version(s)
2019
Good day,
My tracker of all tracker spreadsheets is almost complete.

ABCDE
1NAMELAST REPORTNEXT REPORT30/60/90DAYS REMAINING
2JOE201906112020060960 DAYS35
3BILLS20200410SENT

I have established the formula for E2:
=IF((C2-NOW())<0,"OVERDUE",C2-NOW())

but now I would like to add the following:
once I send a report for signature, I like to enter "S20200410" in Column B showing S means sent and the date is yyyymmdd (just internal information)

when I enter that in B3, E3 populates with "SENT" and then when I get the report back, I enter my yyyymmdd date format and it reflects similar to row 2 and close out that row.


I have the following:
=IF(ISNUMBER(SEARCH("S",B3)), IF((C2-NOW())<0,"OVERDUE",C2-NOW())

Searching for "S" in B3 and if no S, then continue with the next If statement.

It just doesn't produce anything for me.

Thank you for your amazing help!
 
Try this

=IF(LEFT(B3,1)="SENT", IF(C2<TODAY(),"OVERDUE",C2-TODAY())
 
Try this

=IF(LEFT(B3,1)="SENT", IF(C2<TODAY(),"OVERDUE",C2-TODAY())


Thanks, it was a great spark. I corrected it below and it works like a charm.

=IF(LEFT(B3,1)="S","SENT", IF(C2<TODAY(),"OVERDUE",C2-TODAY())
 
Sorry about that, it was just a typo, honest! :loco:
 
Back
Top