Days running formula with 3 date entries

GraesonG

I am using the following formula to calculate the days running.

Formula is in the "Working Days Remaining" column.

=[Claim Completion Date (8 Days)]@row - TODAY()

What I need it to do is stop the days running once a date have been put into the "Report Sent Date" Column.

GraesonG

Hi Paul

The formula works perfectly!

Thank you for the assistance, much appreciated.

Paul Newcome

Try this:

=[Claim Completion Date (8 Days)]@row - IF([Report Sent Date]@row = "", TODAY(), [Report Sent Date]@row)

GraesonG

Hi Paul

The formula works perfectly!

Thank you for the assistance, much appreciated.

Paul Newcome

Happy to help. 👍️