Countifs more than 30 days old but less than 120 days

[magpie2000k]

I have a date in a cell on a table and I want to use countifs.

I want to say count the number if records where the date (in date and time format DD:MM:YY HH:MM) where the date is over 30 days ago from today and less than 120 days ago where the status of the customer (colum M) is Sale completed)

I keep trying but cant get it to work.
The date is in column g

Thanks

 

[admiral100]

Hi,

=COUNTIFS(A1:A31,"<"&TODAY()-30,A1:A31,">"&TODAY()-120,M1:M31,"Sale completed")