Current location - Training Enrollment Network - Books and materials - Why can't this formula screen out books published in 20 10 and 20 1 1? What's the matter?
Why can't this formula screen out books published in 20 10 and 20 1 1? What's the matter?
It can only be realized by the between function.

To create a new column, fill in the blanks in the fields.

Publication year: year ([publication date])

Please note that the colon before year in the previous line is half-angle.

Fill in the blank of the condition:

Between (20 10 and 20 1 1)

Note that the brackets in the previous line are also half-angle.