Making a report using Lookup and Formulas

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!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.