Problem with formulas and dates

[Юлия Ермилова]

I have problems with counting cells on list "28 days".

Initially i can choose a date on the list Report at B3 and C3 cells and formulas on the "Formulas" list will count the number of cells by formula =COUNTIFS('28 days'!A2:A950;">="&B3;'28 days'!A2:A950;"<="&B4;'28 days'!D2:D950;"=OPP")

The problem is that its not counting the cells with date 14 of May for some reason and its not showing any data when I choose date from 14.05.2018 to 14.05.2018 though it should as I use ">=".

Really would appreciate your help!

[#2 · Accepted solution]

Hi

the dates in sheet 28 days column A are not dates but time stamps. They contain a time part. If you try to count from 14.05.18 00:00 to 14.05.18 00:00 there will no match.

Either remove the time component in sheet 28 days or add a time component in sheet report.

[#3]

Thank you so much! It helped