Auto update of cell query

[Mads765]

Hi,

I want excel to auto update the amount of days based on the date the request was acknowledged.

Example:

        A                       B                                   C

Date Raised         Resolved           Time to complete (days)

10/05/2022               No                              2

The above indicates that I logged the issue on 10/05/22 and as the issue is still not resolved it has taken 2 days so far to complete.

I want column C to auto update the number of days as long as column B is a No based on the start date in Column A. Is this possible?

[#2]

Hi @Mads765 

Assuming data are formatted as a Table (possible with ranges as well):

in D3:

=IF([@Resolved] = "no", TODAY()-[@[Date Raised]], "")

[#3]

Thanks @L z. 

I am now getting the following error when inputting your formula :

[#4]

@Mads765 

No idea where the issue comes from with an error message only

Could you share your workbook i.e. with OneDrive or any other file sharing service?