Subtract two dates based on criteria in a specified field

Community,

Happy Tuesday.

I want to subtract two dates based on the results of a third field.

If the status is closed, then subtract Start Date from End Date.

All other statuses, subtract Start Date from Today().

Please see sample data.

Thanks!

Date Time

Accepted answers

if [status] = "Closed"
then datetimediff([end],[start],'days')
else datetimediff(DateTimeToday(),[start],'days')
endif

Example attached

IF [status] = "closed"

THEN datetimediff([End Date], [Start Date], "days")

ELSE datetimediff(DateTimeNow(), [Start Date], "days")

ENDIF

if [status] = "Closed"
then datetimediff([end],[start],'days')
else datetimediff(DateTimeToday(),[start],'days')
endif

Example attached