SharePoint : How to use [Today] in a calculated field?

Option 1: Create a field named 'Today'. Use it in the formula. Now, delete the 'Today' field.

Option 2 (recommended): If possible, use list views instead. You can use [Today] under filter options.

Here you can compare a date field with [Today]+/-SomeNumber.

Example: Date Field1 < [Today]+100