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.