Hello everyone in the Community! Need some help with formulas.

We are managing content for marketing campaign and need to find a way to make a report in AirTable.

In one table we have all the Post with Post Dates. Another table we plan to use for reports.
So I linked all the planded posts to Posts field. Then using Lookup Post Date (from Posts) I took Post Dates.

I need to check how many posts been posted on a particular week. I’m setting up a week using Start week date.

Can you please help with this?

Thank you!