Vincent Thank you so much! Actually this is what I was able to figure
out thru trial and error last week. I knew i was close with my formula,
the piece i was missing was setting the field name for when the IF
statement was false. Thank you again! Yes, this only calculates going
forward, and like Vincent mentioned it does not overwrite if the status
gets set back again.