I’m taking a look at your provided formula, and whilst I can clean it up to satisfy the syntax, I’d like to know a bit more about your use case since I’m a bit confused about what you’re looking to accomplish.
Even though the formula I provided down below is technically formatted, it might not provide you with the desired result.
If you could hit me with the story of what you’re looking to achieve, it would be easier to troubleshoot and solution.
From what I can tell from the formula, you’re looking to:
- Take a Date/Time, and add two months to the value.
- Find the day of the month from the (original) Date/Time with one month to it.
- Add the day of the month value to the first two-month calculation.
- Format that in
This is the formula that accomplishes that:
Here’s the original formula that you posted.
On line 8, there is a
-, I’m curious if you’re actually looking to subtract the value of the date?
If so, let me know and we can tweak it around.
Regardless, if something seems weird, if I’m misunderstanding something, if it doesn’t work, or if you have any questions, let me know!