General Caster Date Formula Help

Hi everyone,

I am a relatively new Monday.com user and am facing a challenge with a General Caster formula. I am hoping someone can help me resolve it.

My goal is to create an automation that takes a date from my “FYE Date” column, adds 1 year and 11 months to it, and crucially, always sets the resulting day to the last day of November in that calculated year.
e.g. If “FYE Date” is 31 Aug 2024, I want the “Deadline of Form CS” column to show 30 Nov 2025.

The following is the formula I entered myself:

However, when I try to implement this formula, I consistently encounter an error.
Could someone please review my formula and advise on how to make it workable within General Caster? Any guidance or a corrected formula would be greatly appreciated!

On the other hand, I would like to kindly suggest to the General Caster team the possibility of setting up a comprehensive site where users can easily refer to and find examples of various formulas. I believe this would be incredibly beneficial for users, especially those of us who are less familiar with formula syntax, to learn and implement solutions more effectively.

Thank you in advance for your help and consideration.