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
Hi teamHoping 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 Read More