Difference between todays date and another with a 3rd and 4th condition

Hi,

I am really struggling here, have trawled the web but cannot find any help.

I have 2 columns.

A1 contains a date 'Date Raised'

B1 contains a validated drop down 'Status' containing 'Open', 'Closed' & 'Accepted'

I need the query to look through the 'Date Raised' coulmn and identify any dates that are greater than 30 days but less than 120 days outstanding. I then need the query to look at the corrosponding 'Status' column and identify if those records which meet the date criteria have 'Open' or 'Accepted' in their status (I want to ignore all 'Closed' records)

I have tried a lot (and I mean a lot) of different combinations of sumproduct but it is not working,

any help would be greatly appreciated

Are you just wanting to flag the records which match this?

If so, in column C you could put:

=IF(AND(A1>TODAY()+30, A1<TODAY()+120),IF(B1<>"Closed","X",""),"")

this would flag any records which match the criteria with an X in column C.

Sorry,

I should have been clearer.

I need to count the number of records which meet this condition (I will use the same code to return between 120 and 180 days and so on)

I would rather reference the column range in a query then inserting a new column as this can lead to trouble if the formula is dragged down and produces a entry that has no relevence thus upsetting a dashboard where this data is going to be shown. Also, the sheet will be a taking a DB feed which will autopopulate the range so I would not be able to drag down the formula.

cheers for the reply

Thanks DonkeyOte,

Still no joy, returning '0' all the time. ( I had tried this combination a while back)

Is this something that is possible? I know there is a lot of volitility with dates in excel but I am no expert.