Trigger a period for the two previous months

[PGesterkamp]

Hello

On entering a sheet I would like it to be automaticly set for the period of  the two previous months as from today.  I have used:

(in the textfield search I wrote:)

=MONTH(TODAY())-1  (that works, but only for one month). How can I expand my range with 2 months?

[BlondeThursday]

This is brilliant for my application.

How would you alter it to select all of the previous six months before today?

[BlondeThursday]

Sorry, asked before looking at it properly.

='(' &(month(AddMonths(today(),-4)))&'|'&(month(AddMonths(today(),-3)))&'|'&(month(AddMonths(today(),-5)))&'|'&(month(AddMonths(today(),-2)))&'|'&(month(AddMonths(today(),-1)))& ')'