Forum Discussion

Andy1883's avatar
Andy1883
Copper Contributor
Jun 10, 2024

Counting days

Hi team

Hoping you can assist with a tricky one.

I am counting the number of days between when a job is received, to when it is completed.  I have been using TODAY() as the end date which gives me the age of outstanding jobs, but how can I get it to stop counting when completed?  Can I get it to reference when another cell is filled in, indicating the job is complete?  eg job is complete when column G is filled in.

 

 

 

Cheers

 

 

 

Formulas and Functions

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jun 11, 2024

    Andy1883 Well, the basic structure of such a formula would be:

    =IF(
   ISBLANK(G...),
   DAYS(end_date, start_date),
   DAYS(TODAY(),start_date)
)

     

    Obviously, replace G... with a reference to "Total Distance (m)" and start_date to "Approval Date". That leaves us with determining the end_date. I see no column for it in your table so you would have to insert one where you can enter it as soon as column G gets entered. But then you can also directly refer to that column, of course, when you check if a job is complete.

Resources