Stop a formula if a cell has a certain text and show the last count where it stopped

[Alishk]

Hello experts,
So i am stuck here.

B = has a past date "01/10/21"
F = has a shipment date (if shipped)
G = has either "Shipped" "Processing" or "Canceled"
H = is counting days =TODAY()-$B2

what I want either
if F has a date
H should stop counting days further and show counted days (the difference between B date and F Date)

OR
if G is either "Shipped" or "Cancelled"
H should stop counting days further and show counted days till G value is shipped or canceled.


i also attached my sheets picture

 

[alz]

Hi! Try this
=IF(F2="",TODAY()-B2,"")

or this!
=IF(F2="",TODAY()-B2,F2-B2)

 

[Alishk]

Yes this solves the problem, with new problems accruing,
if F2 and B2 both are empty it starts showing 44224 Days. It should keep it black until B2 is populated.

 

[Alishk]

Yes this solves the problem, with new problems accruing,
if F2 and B2 both are empty it starts showing 44224 Days. It should keep it black until B2 is populated.

Hi! Try this
=IF(F2="",TODAY()-B2,"")

or this!
=IF(F2="",TODAY()-B2,F2-B2)

 

[Alishk]

BLANK*

 

[alz]

Try This!
=if(And(f2="",B2=""),"",IF(F2="",TODAY()-B2,F2-B2))

 

[Alishk]

Try This!
=if(And(f2="",B2=""),"",IF(F2="",TODAY()-B2,F2-B2))

Its now showing FALSE and if F2 and B2 is black it is still showing 44224 days

 

[Alishk]

Try This!
=if(And(f2="",B2=""),"",IF(F2="",TODAY()-B2,F2-B2))

ok i tried on a new sheet. now its working but still if F2 has a date and B2 is black its showing 44224 days

 

[alz]

=if(And(f2="",B2=""),"",if(b2="","",IF(F2="",TODAY()-B2,F2-B2)))

Try!

 

[Alishk]

=if(And(f2="",B2=""),"",if(b2="","",IF(F2="",TODAY()-B2,F2-B2)))

Its woks thank you