Countifs matrix with date and time elements

[b19upj]

Hi,

I am looking to work out if a list of items have been Completed, Due or Overdue.
For completed, it should be in last: 24h, 48h, 72h, 5 days, 10 days.
For Due, it should be in next: 24h, 48h, 72h, 5 days, 10 days, more than 10 days.
For Overdue, it should be overdue by: 24h 48h 72h, 5 days, 10 days, more than 10 days.

I have a status column at AB
A completed date column at V
A completion due date column at T
- annoyingly all the dates are formatted like this 27/02/2015 10:31:55

My code is not producing any results.
For Completed:
=countifs($AB:$AB,"Completed",$V:$V,NOW()-1
I then change the -1 to -2, -3, -5, -10.

For Due:
=countifs($AB:$AB,"In Progress",$T:$T,NOW()+1
I then change the +1 to +2, +3, +5, +10, >+10

For Overdue:
=countifs($AB:$AB,"In Progress",$T:$T,NOW()-1
I then change the -1 to -2, -3, -5, -10, >-10

Nothing is working. I suspect its something to do with the date format, but am not sure.

Any help appreciated.

 

[Special-K99]

The forum has corrupted your post and it is unreadable.
Please edit your post and place a space before and after any carats < >

 

[b19upj]

Ok, here goes take two...


I am looking to work out if a list of items have been Completed, Due or Overdue.
For completed, it should be in last: 24h, 48h, 72h, 5 days, 10 days.
For Due, it should be in next: 24h, 48h, 72h, 5 days, 10 days, more than 10 days.
For Overdue, it should be overdue by: 24h 48h 72h, 5 days, 10 days, more than 10 days.

I have a status column at AB
A completed date column at V
A completion due date column at T
- annoyingly all the dates are formatted like this 27/02/2015 10:31:55

My code is not producing any results.
For Completed:
=countifs($AB:$AB,"Completed",$V:$V,NOW()-1
I then change the -1 to -2, -3, -5, -10.

For Due:
=countifs($AB:$AB,"In Progress",$T:$T,NOW()+1
I then change the +1 to +2, +3, +5, +10, > +10

For Overdue:
=countifs($AB:$AB,"In Progress",$T:$T,NOW()-1
I then change the -1 to -2, -3, -5, -10, > -10

Nothing is working. I suspect its something to do with the date format, but am not sure.

Any help appreciated.