I wrote a function that calculates the max worked over any 17 week period but
when I put it in the worksheet it would only calculate when edited.

It was in a module.


I do not know what is going wrong. When I put it in a conditional format it
did nothing.