Simple Date Function

JayTeeDee

=[Actual Closure Date]@row - [Deviation Opened]@row

For fields that don't have a date, currently showing up as #Invalid Operation. Would like it to display blank instead. Thank you.

Paul Newcome

You would need to wrap it in an IFERROR function.

=IFERROR([Actual Closure Date]@row - [Deviation Opened]@row, "")

Paul Newcome

You would need to wrap it in an IFERROR function.

=IFERROR([Actual Closure Date]@row - [Deviation Opened]@row, "")

JayTeeDee

Thanks @Paul Newcome

Paul Newcome

Happy to help. 👍️