How to count the number of days since the last "accident" with two variables?

[98Hodge]

I have attached a sample file.

I'm looking for a formula that counts the number of days it has been since the last 'accident' where the type of injury is not 'property damage'. The current formula I am using is =IF(Table1[Type of report]="Accident",DATEDIF(Table1[Date and time],TODAY(),"D"),"") but this includes all accidents including property damage which I need to exclude. Is there any way of achieving this?

Any help is appreciated, thanks.

TEST.xlsx

[etaf]

EDIT
re read an i think you want
=IF(AND(Table1[@[Type of report]]="accident", Table1[@[Type of Injury]]<>"property damage"),TODAY()-Table1[@[Date and time]],"")




try
=IF(Table1[@[Type of Injury]]<>"property damage", TODAY()-Table1[@[Date and time]],"")

[98Hodge]

EDIT
That's exactly what I needed.

I've been trying to do that for a couple of days now and you've solved it in minutes, thanks again!


----------------------------------------------------------------------------------------------------------------------------------------

Thanks for the reply!

I'll give it a try and get back to you.