calculate using rolling calendar

[Martha]

I need a formula to calculate attendance on a rolling calendar, updating date
each time you open

 

[Bob Phillips]

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