Ageing in Days with multiple conditions

[TS08]

Hi,

Could anyone please help me calculate the days while comparing two dates with some additional conditions. 

e.g. date difference b/w RFS Date and Timestamp if status is not equals to "Commissioned" or "Termination"  and RFS date is not Blank

I was trying below formula but it's not working: -

=If([Status] -='Commissioned' and 'Termination' and Len(Trim([RFS Date ]))>0,
([RFS Date ]-[Timestamp]),'No CRF Date')

[BrunPierre]

As below

IF(Not Match(Status,'Commissioned','Termination') and Len(Trim([RFS Date]))>0,Interval(RFS Date]-[Timestamp],'dd')) as  Days

[TS08 · Accepted solution]

Thanks a lot, this is really helpful 🙂