T
tuk16664
Hi
Im using networkdays calculation to work out the time between two dates but
im having a bit of trouble with a formula to then count these numbers in a
different cell.
In the other cells i have the specific ranges i need to count so between 0-2
days, 3-5 days and then 6+ days so for the first cell i would assume that i
need a formula to count with the criteria being >=0 and <=2 then so on.
I can get it to work when there is only 1 criteria ie.
=COUNTIF(G23:G210,">=6") but cant seem to work it to count the numbers
between the two points as above.
Many thanks for your help
Matt
Im using networkdays calculation to work out the time between two dates but
im having a bit of trouble with a formula to then count these numbers in a
different cell.
In the other cells i have the specific ranges i need to count so between 0-2
days, 3-5 days and then 6+ days so for the first cell i would assume that i
need a formula to count with the criteria being >=0 and <=2 then so on.
I can get it to work when there is only 1 criteria ie.
=COUNTIF(G23:G210,">=6") but cant seem to work it to count the numbers
between the two points as above.
Many thanks for your help
Matt