Forum Discussion

Kiripong's avatar
Kiripong
Copper Contributor
Jun 03, 2020
Solved

Tracking Delay Day

Hello Guys,   Please help I want to track the delay day based on received date. 1. Let say I have 3 days to review the document if I send out on time I want the cell in column "DELAY (DAYS)" input...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 04, 2020

    Kiripong Assuming the left most header cell    is in A1, try the following formula in E2 and copy it down.

    =MAX(0,TODAY()*(D2="")+(D2*(ISNUMBER(D2))-C2-3))

    If you want to make it a bit more dynamic, change the REMARKS  column to contain the number of days allowed for review only. Then you can can replace the "-3" at the end with "-F2". This would allow for different numbers of review days allowed for different documents. 

Kiripong's avatar
Kiripong
Copper Contributor
Jun 14, 2020

Riny_van_Eekelen, Sorry to bothering and this question was out of the context yet if you can help that would be awesome and to be more dynamic please see below query:

How to joint text string as per Column C2-C5 base on item A, B , C or D between these 2 tables:

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 14, 2020

Kiripong Indeed, this is out of context. Better to start a new conversation for in such cases. But never mind. Attached a quick-and-dirty solution for you.

 

Resources