Hello Everyone, not sure if this question needs to be here or formulas?

My Company is a VOD service, We are creating a content programming grid and a calendar view for our episodes daily content: We want to address each episode to its specific date in an automated way to know the volume of the content in a daily bases.

For example, I have Release Date, Pattern Release/Week “7”, and No of Episodes.

there are some conditions excluding weekends, not applicable with all titles though. I have created that formula that gives me the end date

IF({Release Pattern}=5,

IF(DATETIME_FORMAT({Start Date}, ‘dddd’)=“Sunday”

,

DATEADD({Start Date},IF(INT(Eps/{Release Pattern})=Eps/{Release Pattern},((Eps/{Release Pattern})*7)-(8-{Release Pattern}),(ROUNDDOWN((Eps/{Release Pattern}),0)*7)+(Eps-({Release Pattern}*ROUNDDOWN((Eps/{Release Pattern}),0)))-1),‘days’)

,

DATEADD({Start Date},IF(INT(Eps/{Release Pattern})=Eps/{Release Pattern},((Eps/{Release Pattern})*7)-(8-{Release Pattern}),(ROUNDDOWN((Eps/{Release Pattern}),0)*7)+(Eps-({Release Pattern}*ROUNDDOWN((Eps/{Release Pattern}),0)))-1)+2,‘days’))

,

DATEADD({Start Date},IF(INT(Eps/{Release Pattern})=Eps/{Release Pattern},((Eps/{Release Pattern})*7)-(8-{Release Pattern}),(ROUNDDOWN((Eps/{Release Pattern}),0)*7)+(Eps-({Release Pattern}*ROUNDDOWN((Eps/{Release Pattern}),0)))-1),‘days’))

I still want a function that set each episode to the right release date without doing that Manually, for example, we have Prison Break S1: release Pattern/Week=5: Episode No:18 Release date: 8/9/2020 Then the result is:9/1/2020, so I want to see each episode on the right release date in a grid view or calendar view following the release dates in a daily, weekly and monthly bases

Is there a way to figure out all of that in Airtable? or a block can do that?

I also have Zapier as a premium account if there is a need, Sorry for the long Description, I am just trying to give you a full idea.