Countifs for due and overdue dates and times

[b19upj]

Hi,


I want to create a formulae to see how many things are due and overdue by 24h/48h/72h/5d/10d/>10days.
All things due or overdue will say "In Progress" in column AD and the Completion Due Date and Time is in column U.
My formulae for Due in 24h is: =COUNTIFS(Data!$AD:$AD,"In Progress",Data!$U:$U,">="&NOW()+1)
My formulae for Overdue in 24h is: =COUNTIFS(Data!$AD:$AD,"In Progress",Data!$U:$U,">="&NOW()-1)
To change to 24/48/72/5/10/>10 I change the end number to +1/+2/+3 etc and for overdue -1/-2/-3 etc.
I want to know what is due/overdue in 24h, 48h, 72h in those times but my formulae is giving me the total that say "In Progress" without taking the date and time into account.


Any ideas what im doing wrong?


TIA

 

[jorismoerings]

Hi,

At a first glace there nothing wrong with your formula.
Care to share some sample data and an expected result?