Countifs calendar date due or overdue

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

Are the dates in column U true dates or text entries that look like dates?

If you can't tell, then can you attach a sample workbook?

Yes, the number format is set to date. It displays dd/mm/yyyy but the cell is set as dd/mm/yyyy hh:mm:ss

If the cells is set to format of dd/mm/yyyy hh:mm:ss, then the display should be of the same format...

I suggest you attach a sample file to better diagnose it.