I think more details and some example data and results would help us here.

--
HTH

Bob Phillips

"Martha" wrote in message
...
I need a formula to calculate attendance on a rolling calendar, updating
date
each time you open