I have a custom field on the Account Object called Account Status.  It has three values, Current, Lapsed, null. 

I am trying to create a workflow rule that looks at all of the contracts within an account and evaluates the start and end dates.  If the latest contract end date is a date in the past it would update Account Status to "Lapsed"

Any help is greatly appreciated.  Thanks