I've found that the Formula field does not update it's results dynamically if any of the data changes.  I wondered, are formula fields supposed to update?  

Many thanks,

Katie