Auto update of cell query

%3CLINGO-SUB%20id%3D%22lingo-sub-3363057%22%20slang%3D%22en-US%22%3EAuto%20update%20of%20cell%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3363057%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20excel%20to%20auto%20update%20the%20amount%20of%20days%20based%20on%20the%20date%20the%20request%20was%20acknowledged.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EExample%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3CSTRONG%3E%20A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BB%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BC%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EDate%20Raised%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BResolved%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BTime%20to%20complete%20(days)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E10%2F05%2F2022%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BNo%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20above%20indicates%20that%20I%20logged%20the%20issue%20on%2010%2F05%2F22%20and%20as%20the%20issue%20is%20still%20not%20resolved%20it%20has%20taken%202%20days%20so%20far%20to%20complete.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20column%20C%20to%20auto%20update%20the%20number%20of%20days%20as%20long%20as%20column%20B%20is%20a%20No%20based%20on%20the%20start%20date%20in%20Column%20A.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3363057%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3363138%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20update%20of%20cell%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3363138%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388033%22%20target%3D%22_blank%22%3E%40Mads765%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%20data%20are%20formatted%20as%20a%20Table%20(possible%20with%20ranges%20as%20well)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22_Screenshot.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371109i14491CDDB530C1DB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22_Screenshot.png%22%20alt%3D%22_Screenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ein%26nbsp%3B%3CSTRONG%3ED3%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(%5B%40Resolved%5D%20%3D%20%22no%22%2C%20TODAY()-%5B%40%5BDate%20Raised%5D%5D%2C%20%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3371511%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20update%20of%20cell%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3371511%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F75890%22%20target%3D%22_blank%22%3E%40L%20z.%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20now%20getting%20the%20following%20error%20when%20inputting%20your%20formula%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Mads765_0-1652455323586.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371490i96A808319994B1B4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Mads765_0-1652455323586.png%22%20alt%3D%22Mads765_0-1652455323586.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3372103%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20update%20of%20cell%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3372103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388033%22%20target%3D%22_blank%22%3E%40Mads765%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20idea%20where%20the%20issue%20comes%20from%20with%20an%20error%20message%20only%3C%2FP%3E%3CP%3ECould%20you%20share%20your%20workbook%20i.e.%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fshare-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ewith%20OneDrive%3C%2FA%3E%20or%20any%20other%20file%20sharing%20service%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

3 Replies

Hi @Mads765 

 

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

_Screenshot.png

in D3:

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

Thanks @L z. 

 

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

 

Mads765_0-1652455323586.png

 

@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?