Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
Thanks a lot, this is really helpful 🙂
As below
IF(Not Match(Status,'Commissioned','Termination') and Len(Trim([RFS Date]))>0,Interval(RFS Date]-[Timestamp],'dd')) as Days
Thanks a lot, this is really helpful 🙂