I’m currently working on what feels like it should be a relatively simple formula, but I’m consistently getting a #ERROR! result when I try to implement it.
Context is: I have a table that lists students’ work experiences, their start dates and end dates. I want a filtered list of records where either the start date or end date was in the month before the previous month. e.g. if I was looking at it at the end of May, I’d want to see all work experience that started or ended in the month of April.
This is the formula I’ve written:
As I said, I’m getting a consistent error message on this formula. Apologies if I’ve missed something incredibly simple, but would anyone be able to cast a fresh pair of eyes over this and point out any mistakes I’ve made?
Thanks so much for your help!
Solved! Go to Solution.
That fixed it! Thanks Grunty!
The source of the problem is me writing out my formula in a separate notes app, and then copying and pasting it in. Retyping the apostrophes in Airtable seemed to fix the issue.