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.
I’m having trouble with general caster’s dates but a different problem, but I asked copilot/AI your question it gave me the below. Maybe it will help. If not maybe build the formula in a regular monday formula field and copy over so you get the column names exactly right.
Thanks for sharing the image! The formula you entered has a couple of issues:
Incorrect use of TEXT function: The second argument “1” is not a valid date format string.
Concatenation of strings: You’re building a string like “20241130”, but this doesn’t automatically convert to a date.
Missing logic to add 1 year and 11 months: The formula doesn’t yet add the required time to the original date.
General Caster-Compatible Formula
Here’s a formula that should work for your use case:
How It Works:
DATEVALUE({Taxation’s FYE Date}): Converts the column value to a date.
YEAR(…) + 1 and MONTH(…) + 11: Adds 1 year and 11 months.
DATE(…, …, 1) - 1: Goes to the last day of the previous month, which will be November 30 of the target year.
TEXT(…, “YYYY-MM-DD”): Formats the result as a string so General Caster can cast it into a date column.
How It Works: