indi visual
Member
I use a basic countif to count the number of jobs due today. It counts the current date down the column and lets me know how many jobs are due that day.
However,
I noticed that if the job goes late into the next day, and the completed cell is empty, then the counter does not know that this job still needs to be accounted for.
If I had a formula with something along the lines of if the date due column is today or in the past, and the completed column is empty, then count.
I can use conditional formatting to highlight it red, but I want my counter to recognize past due jobs as well. Which means it would have to count based on multiple criteria.
However,
I noticed that if the job goes late into the next day, and the completed cell is empty, then the counter does not know that this job still needs to be accounted for.
If I had a formula with something along the lines of if the date due column is today or in the past, and the completed column is empty, then count.
I can use conditional formatting to highlight it red, but I want my counter to recognize past due jobs as well. Which means it would have to count based on multiple criteria.