There are several problems that I see…

- You’re using styled quotes in your formula. Airtable formulas only work with non-styled quotes. I’m guessing you copied some/all of that formula from an online source where the quotes were styled (perhaps somewhere in this forum?). Just retype the quotes manually and you should get non-styled quotes
- There are several places where you put a space between a function name and its opening parenthesis. This is an invalid function call. For example
`TODAY()`

is correct, but `TODAY ()`

is not.

On a side note, the logic of your formula is a little off in the “This week” and “This month” sections. You’re comparing the due date against a date modified from today using the `=`

operator, which means that only a date *exactly matching* that modified date—either 7 or 30 days out, depending on the section—will create the desired output. What you should be doing is checking to see if the due date is *less than* (i.e. before) the modified date in each case. That will apply the desired label across a span of days, not just on a single day.

Here’s your formula with all of those changes applied:

```
IF({Due Date} = TODAY(), "Today",
IF({Due Date} < DATEADD(TODAY(), 7, "days"), "This week",
IF({Due Date} < DATEADD(TODAY(), 30, "days"), "This month")))
```

Also be aware that `TODAY()`

is calculated based on GMT, not your local timezone. Depending on where you live, you might see items match “Today” during a certain part of the day, but then change to having no label later the same day. That change will happen when GMT rolls over to the next day. There are ways to work around this, but it makes the formula more complicated. If you want help setting that up, just holler.

The false argument in the “if” function is optional. The docs don’t mention this, sadly. If omitted, the output is automatically blank.