How do I count how many records that have the same value in a field?

Hi,

I am working on a project where invntory can be rented for a certain period. I need a formula to count how many records that have requested a rent for the same day. When I know this, I can set the status as ‘unavailable’ or ‘available’ if too have requested the product for the same day.

Thank you!