Working with Fiscal Year dates and counting attendance

[CarlHolmes]

This is the link to a previous post. Not sure it will help but may provide some additional inspiration.

Financial Year based on my date column?

I hope I’ve understood the requirement correctly. There may be an easier way to do it with only using one field but I’ve had to use an equation and then a text forumula