Need a formula to count number of days past a deadline if the work is not complete

A Kempf

I have the following fields: Document Signature Required Date and Document Signed Date.

I need to have a formula that shows the number of days from Document Signature Required Date until today, if the Document Signed Date field is empty. So basically, if there is no completed date, how many days has it been on hold.

I've tried a dozen different configurations and I can't get it to work.

Hollie Green

=IF([Document Signed Date]@row = "", TODAY() - [Document Signature Required]@row, "")

Hollie Green

=IF([Document Signed Date]@row = "", TODAY() - [Document Signature Required]@row, "")

A Kempf

Yes! That one worked… thank you so much!